|
Posted by Hendri Kurniawan on 01/04/07 13:52
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
Navigation:
[Reply to this message]
|