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'];

• Next in forum: Opening Excel on client side
• Prev in forum: Re: Breaking backwards compatibility - good or bad?
• Thread view: Re: displaying the result of a COUNT query in MySQL

[Reply to this message]