Posted by william.clarke@gmail.com on 12/20/05 23:59

briansmcc try your SQL like this...

$result6 = mysql_query('SELECT COUNT (movie_id) as quant FROM movies
WHERE divx = 1 AND format = 'reg') or die(mysql_error());
$movie_count = mysql_fetch_array($result6 );

later on the page:
echo $movie_count['quant'];

[Back to original message]