Page 1 of 1
count
Posted: Tue Jul 22, 2003 8:40 am
by superman
is this code correct? but i got this error message 'Resource id #2'
<?
$Connect = mysql_connect("localhost","root","");
mysql_select_db("mw");
$result=mysql_query("select count(StaffID) from LeaveApplication1 where StaffID = 'fui'") ;
echo "$result";
mysql_close();
?>
Posted: Tue Jul 22, 2003 8:53 am
by cactus
The value of $result is a pointer to your result set returned from your query, you will need a few extra steps to get the data out of your table.
Depending on the amount of data return you will need to use either:
mysql_fetch_row() :
http://uk2.php.net/manual/en/function.m ... ch-row.php
or
mysql_fetch_array() :
http://uk2.php.net/manual/en/function.m ... -array.php
Code: Select all
<?
$Connect = mysql_connect("localhost","root","");
mysql_select_db("mw");
$result = mysql_query("select count(StaffID) from LeaveApplication1 where StaffID = 'fui'") ;
$row = mysql_fetch_row($result)
var_dump($row);
mysql_close();
?>
There are other methods that you can use, but these are the nost common and should return what you need.
Regards,