Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff
Author Message
hireamerica
Client


Joined: Sep 30, 2004
Posts: 103
Location: New Jersey

PostPosted: Thu Nov 18, 2004 3:18 pm Reply with quote

I'm getting null from a numrows against a query I know has 1 row returned.

Code:
$foreigners = "select name, user_city, user_state from ".$prefix."_users left join ".$prefix."_states on user_state = short_name where short_name is null";


$if_foreign = $db->sql_numrows($foreigners);


Shouldn't this return a value of 1? if the actual query returns 1 row when fetched?

Code:
echo "if_foreign value is equal to $if_foreign";
--> if_foreign value is equal to
 
View user's profile Send private message Visit poster's website Yahoo Messenger
hireamerica
PostPosted: Thu Nov 18, 2004 3:26 pm Reply with quote

ah...dang nab it.... fixed it... need to numrows the return of the sql_query, not the sql itself.
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©