try this:
-> $sqlcom="select count(codigo) as cnt from comments where codigo=$id";
$resultadocom = mysql_db_query ("database",$sqlcom);
$registocom = mysql_fetch_array($resultadocom);
-> $contador = $registocom["cnt"];
print("comentarios= $contador");
the lines marked with -> are the lines I changed
-----Original Message-----
From: Pag [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 20, 2002 9:38 AM
To: [EMAIL PROTECTED]
Subject: [PHP] database value count retrieval
>SELECT COUNT(x) FROM table;
>
>Make 'x' equal to any column name in the table and add WHERE to the
>clause as needed.
err...all very well, but how do i retrieve the value afterwards?
Heres my code:
$sqlcom="select count(codigo) from comments where codigo=$id";
$resultadocom = mysql_db_query ("database",$sqlcom);
$registocom = mysql_fetch_array($resultadocom);
$contador = $registocom["codigo"];
print("comentarios= $contador");
Nothing comes out, although i dont have a clue on how to retrieve
the result after the fetch_array. :-P
/Pag
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
