Smarty

superman · Smarty Rookie Joined: 08 Jul 2003 Posts: 11

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

messju · Posted: Tue Jul 22, 2003 3:26 pm Post subject:

the code is correct and the return-value is also correct. but this is absolutely not smarty related (read: off-topic).

maybe you want to read: http://www.php.net/manual/en/function.mysql-fetch-row.php

boots · Posted: Tue Jul 22, 2003 6:51 pm Post subject:

@messju: YES, the above does correctly printout the fact that mysql driver returns a RESOURCE, but if that's what was desired, we probably wouldn't have heard about it.

I don't think it is correct in that he probably wants to read the CONTENTS of $result using one of the mysql_* functions (as you suggested).

@superman: Anyhow, its still not Smarty but I suggest you read AT LEAST the PHP man page for MySQL.