MySQL Doesn't return Resultset, or errors???

[pbillock]

Some things I do know:
- I have querries above and below this one that are working.
- the table is in the db
- The fields in the table are named properly
- the query , when PRINTED to the screen can be executed in phpMyAdmin properly.
- When I try to print out the mysql_errno or mysql_error, I get nothing.

when I do "SELECT 1" I am returned 1 ( the connection to the db is working)

the sql looks like this:

SELECT field1 FROM table WHERE field2 = 151 AND field3 = 13;


it's that simple but gives me nothing.

if I replace field1 with "count(*)" it also gives me nothing.

Another thing.. this is within a while loop with other querries being performed around it. but all the rest of them are working.. only this one is problematic.
it has me extremely stumped.
:confused:

[chump2877]

I think you need to include more of the surrounding code so people can get an idea of where the error might be....your SQL query looks OK...show us the surrounding PHP code or whatever.... :D

[raf]

also, post the exact query. what use is 'the sql looks like this' :confused: