I am passing a query to a mysql database similar to this:
select id1,id2 from tablename where id3="value" order by id2,id4 limit 1
If I just do this as a direct query to the database it returns what I want (minus the limit 1 for some reason it doesn't like me passing that as a direct query).
However, if I do it from a php script I don't get what is expected. Like say I did this before and it returned id2=3 and I set id4=1 later on and then went back and made id4 null again it will return id2=4 even though id4 is null and not 1 anymore, and each time it just keeps returning the next id2 in line.
I know that's kinda wierd and hard to figure out what I mean. If you need anymore clarifications, just let me know.
Thanks,
Josh
