Page 1 of 1

display count results

Posted: Thu Aug 23, 2007 11:30 pm
by nhan
how can i display the result with this query below....

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;
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

Re: display count results

Posted: Fri Aug 24, 2007 12:10 am
by Christopher
Doing a query would help a little:

Code: Select all

$sql = "select count(ticketnum) AS ticket_count from datatable where date_1 between '2007-6-01 00:00:00' and '2007-7-01 00:00:00'";
$result = mysql_query($sql, $link);
if( mysql_num_rows($result) != 0 ) {
	$row = mysql_fetch_assoc($result);
	echo "# of tickets = {$row['ticket_count']}<br/>";
}

Posted: Fri Aug 24, 2007 12:44 am
by nhan
its working now.....! :D