Posted by J.O. Aho on 09/14/06 19:17

twomt wrote:
> Hi,
>
> am doing something wrong, for sure... I just fail to see it atm where
> the failure is. Call me stupid :p
>
> Someone have a look please
>
> <?php
>
> require 'inc/mysql.inc';
> require 'inc/functions.inc';
>
> $result = mysql_query ("SELECT count(*) FROM User", $connection);
if($result) {
$row=mysql_fetch_array($result);
echo $row[0];
} else {
echo "Didn't find any users in the User table.\n";
}
>
> ?>
>
>
>
> The answer I get is Resource id#4 instead of 6 which is the number of
> rows in the User table.

Yes, you haven't fetched the data, you need to use mysql_fetch_array() or any
other of the fetch functions, the resource is used to tell what you want to
fetch (can do more than one query at the same time).


//Aho

[Back to original message]