Topic: [SOLVED] COUNT not working

[xstevey_bx]

<?php
function newmessages() {

$query = "SELECT COUNT(id) FROM messages WHERE to_id='$_SESSION[uid]'";

$result = mysql_query($query);

$row = mysql_fetch_assoc($result);

$num_rows = $row['COUNT(id)'];

echo 'Message Inbox (' . $num_rows .')';
}

?>


The above statement works, However when I introduce an AND statement it breaks, even though the column name is correct... I dont know whats going on?


<?php
function newmessages() {

$query = "SELECT COUNT(id) FROM messages WHERE to_id='$_SESSION[uid]' AND read='0'";

$result = mysql_query($query);

$row = mysql_fetch_assoc($result);

$num_rows = $row['COUNT(id)'];

echo 'Message Inbox (' . $num_rows .')';
}

?>

[neil.johnson]

Can you print the mysql error using
mysql_query($query) or die(mysql_error());

[xstevey_bx]

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 'read='0'' at line 1

Lol I could have told you that haha

I know it had something to do with the AND part of the statement

[neil.johnson]

READ is a mysql reserved word. You cannot use it as a field name.

http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

[xstevey_bx]

Bingo!! thanks so much!