SQL question: Count

Pellefant

Hello!

How do I count the fieds where approve=0 and then echo the number out please?

Now I get this annoying error msg:

Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COUNT FROM reviews WHERE approve=0' at line 1 in query: COUNT FROM reviews WHERE approve=0

<?php
$Link = mysql_connect("localhost", "user_user", "password");
mysql_select_db("user_tonydb", $Link);

$Query = "COUNT * FROM reviews WHERE approve=0" or die (mysql_error());

$Result = mysql_query($Query) or die("Error: ".mysql_error()." in query: ".$Query);

$row=mysql_fetch_array($Result);
?>

You have X new reviews to have a look at.

xblue

Pellefant,

you really should start using the manual. it's so simple, only go to www.mysql.com and enter 'count' in the search box.

http://www.mysql.com/doc/en/Counting_rows.html
look at the example, it is SELECT COUNT() instead of COUNT - note the SELECT keyword and the parentheses.

Pellefant

Originally posted by xblue
Pellefant,

you really should start using the manual. it's so simple, only go to www.mysql.com and enter 'count' in the search box.

http://www.mysql.com/doc/en/Counting_rows.html
look at the example, it is SELECT COUNT() instead of COUNT - note the SELECT keyword and the parentheses.

Hello!

Thanks for the advice, will try to use the manual more further on. Seems nice. Guess I only have little problem with the "formal"/"strict" language there.

The SQL query now seems to work fine. 🙂 Sorry to ask another thing, that I didn't find at the link..... 🙁

After having the last line:

$row=mysql_fetch_array($Result);

How do I get the result on the screen? ( I have tried several ways now). Or....may I ask about another lechture on how to find that also in the manual, so I get the hang of it.

Thanks a lot for the help.

xblue

mysql_fetch_array returns each row both as numerically indexed and associative array, so you've got the choice.

it's either
$row[0]

or, if you want to get it by name, I'd use an alias in your query:
SELECT COUNT(*) AS rowcount FROM ...
and then it's
$row['rowcount']

Pellefant

Thank you Sir/Madam.