Count

[benbox]

hi

does anyone know why this doesnt work?

it just returns Resource ID 2

thanks

$count = mysql_query("SELECT count(*) FROM news") ;

print $count ;

[hand]

$query = "SELECT count(*) as multimediaspeakersystem FROM news";
$result = mysql_query($query)
	or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

while ($line = mysql_fetch_array($result)) { 
	print "$line[multimediaspeakersystem]<br>\n"; 
} 

or

$query = "SELECT count(*) as multimediaspeakersystem FROM news";
$result = mysql_query($query)
	or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

$line = mysql_fetch_array($result); 
print "$line[multimediaspeakersystem]<br>\n";