display count results
Posted: Thu Aug 23, 2007 11:30 pm
how can i display the result with this query below....
it always gives me this error:
PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\data\projects\data\test\calendar.php on line 27
Code: Select all
select count(ticketnum) from datatable where date_1 between '2007-6-01 00:00:00' and '2007-7-01 00:00:00'
if( mysql_num_rows($result) != 0 ) {
$row = mysql_fetch_row($result);
$data=$row[0];
print $data;PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\data\projects\data\test\calendar.php on line 27