Go Back   CodingForums.com > :: Server side development > MySQL

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Old 01-22-2005, 04:46 AM   PM User | #1
pbillock
New to the CF scene

 
Join Date: Jan 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
pbillock is an unknown quantity at this point
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.
pbillock is offline   Reply With Quote
Old 01-22-2005, 05:41 AM   PM User | #2
chump2877
Senior Coder

 
chump2877's Avatar
 
Join Date: Dec 2004
Location: the U.S. of freakin' A.
Posts: 1,890
Thanks: 5
Thanked 22 Times in 18 Posts
chump2877 is on a distinguished road
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
chump2877 is offline   Reply With Quote
Old 01-22-2005, 12:47 PM   PM User | #3
raf
Master Coder


 
Join Date: Jul 2002
Posts: 6,589
Thanks: 0
Thanked 0 Times in 0 Posts
raf is on a distinguished road
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
raf is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 11:34 AM.

Home - Contact Us - Archives - Link to CF - Resources - Top 

Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.