count

skyloon · #1 22-Jul-2003, 07:34

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();
?>

JdS · #2 23-Jul-2003, 05:49

$result is just a 'result resource' so it's no surprise that you get that back.

Since you asked for one 'result' expecting just a sum of all the records that matched that criteria, you can try using:

PHP Code:


<?php

$Connect = mysql_connect("localhost","root","");
mysql_select_db("mw");
$result = mysql_query( "select count(StaffID) from LeaveApplication1 where StaffID = 'fui'") ;
// echo "$result";  to be replaced by...
$total = mysql_result( $result, 0, 0 );
// the "0, 0" above is row 0 and field 0
echo $total;
mysql_close();
?>

Please look up the function mysql_result() at php.net for some important notes regarding the use of this function.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
count date	skyloon	MySQL / PHP Forum	2	01-Jul-2003 01:28
FAQ - Challenger Forum	JdS	Learning Journal by J de Silva	0	11-May-2002 02:28

count

Use mysql_result() function for this...