![]() |
|
|
|||||||
![]() |
|
|
Thread Tools | Rate Thread |
|
|
PM User | #1 |
|
New to the CF scene Join Date: Jan 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
![]() |
MySQL Doesn't return Resultset, or errors???
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.
|
|
|
|
|
|
PM User | #2 |
|
Senior Coder ![]() Join Date: Dec 2004
Location: the U.S. of freakin' A.
Posts: 1,890
Thanks: 5
Thanked 22 Times in 18 Posts
![]() |
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....
__________________
Regards, R.J. Media Moguls Cleveland, Ohio Web Site Design and Application Development |
|
|
|
|
|
PM User | #3 |
|
Master Coder ![]() ![]() Join Date: Jul 2002
Posts: 6,589
Thanks: 0
Thanked 0 Times in 0 Posts
![]() |
also, post the exact query. what use is 'the sql looks like this'
__________________
Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Rate This Thread | |
|
|