Posted by Bill on 01/04/07 15:35

Hendri Kurniawan wrote:
> Query-ing mysql from PHP returned a "resource".
> To get the actual result, use mysql_fetch_array (or similar functions).
>
> So:
> $sqlcount = "SELECT count( lingo ) FROM `mainpage` WHERE lingo = \'en\'";
> $resultRES = mysql_query ($sqlcount);
> $resultcount = mysql_fetch_array($resultRES);
> mysql_free($resultRES);
> echo $resultcount[0];
>
> Hendri Kurniawan
>
> Bill wrote:
>> Trying to count number of records in table and use result as a loop.
>>
>> in mysql I use
>> SELECT count( lingo ) FROM `mainpage` WHERE lingo = 'en'
>> I get the correct result of 35
>>
>> How do I use php to get same result and put result into a variable so
>> that i can loop 35 times.
>>
>> I have tried
>> $sqlcount = "SELECT count( lingo ) FROM `mainpage` WHERE lingo = \'en\'";
>> $resultcount = mysql_query ($sqlcount);
>> echo $resultcount;
>> just to check that the number has been generated.
>> But nothing is displayed. Is this the correct way to do this.
>> Thanks in advance
>>
>> Bill
Hi Hendri,
I tried what you said and got the following error. The sql is only going
to give one answer and I can see why you put the argument
$resultcount[0]. Any other ideas on how to get the count. Thanks
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource

[Back to original message]