>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