some issues with $db->sql_numrows($query)

Posted: Thu Nov 18, 2004 3:18 pm

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

Posted: Thu Nov 18, 2004 3:26 pm

ah...dang nab it.... fixed it... need to numrows the return of the sql_query, not the sql itself.