database value count retrieval

From: Date: Mon, 19 Aug 2002 23:37:59 +0000
Subject: database value count retrieval
Groups: php.general 
Request: Send a blank email to php-general+get-113273@lists.php.net to get a copy of this message
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


« previous php.general (#113273) next »