allright, I have a SQL query that, when run directly against my mySQL server through the admin tool, returns two rows.
The very same query returns only one row when run via mysql_query( ) in PHP.
I've checked EVERY possible way this could be a bug in my code, or a 'commit' problem on the database end, and I've even altered the query in the code to remove ALL criteria (so it returns everything) and the row is still missing. (there are currently only two rows in the table).
What sort of things could be causing this bug??
it's basically like this:
Table_1:
ID Name Desc
1 foo fubar!
Table_2:
Other_ID Owner Contact
1 boo booFunction
1 moo mooFunction
my query:
SELECT B.* FROM Table_2 B
INNER JOIN Table_1 A
ON (B.Other_ID = A.ID)
WHERE A.Name = 'foo'
I should get both rows in Table_2 as a return, right? And I do if I run the query in phpmyadmin. But if I run it through PHP I get only the first row. I've even created a stripped down test script to run just this query, and I get the same result.
what gives? This is bizarre!
