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
require 'inc/mysql.inc';
require 'inc/functions.inc';
$result = mysql_query ("SELECT count(*) FROM User", $connection);
echo ($result);
?>
The answer I get is Resource id#4 instead of 6 which is the number of
rows in the User table.
Thanks,
twomt.
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
>
>
>
> 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
J.O. Aho wrote:
> 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
>>
>>
>>
>> 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
erm.... I think I better take a break :p
where's my beer :D
Thanks, knew it was a silly one.