mysql_num_rows not working return 0
Posted: Sat Jul 22, 2006 2:40 am
Weirdan | Please use
$result shows Resource id #16, but $mysql_num_rows($result) still returns zero
any idea?
Weirdan | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
Has anyone ran into problems where mysql_num_rows() return 0 when the result
set clearly contains a certain number of rows? My code looks something
like thisCode: Select all
$conn = db_connect();
$query = "select distinct id from table where MemberID='$ID' and Date='$today'";
$result = mysql_query($query);
if(!$result)
return false;
$num_reply = @mysql_num_rows($result);
if($num_reply==0)
return false;
else
return $num_reply;any idea?
Weirdan | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]