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
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?
$sqlcom=select count(codigo) from comments where
codigo=$id;
SELECT
2 matches
Mail list logo