Jump to content

[SOLVED] COUNT not working


xstevey_bx

Recommended Posts

<?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 .')';
}

?>

Link to comment
https://forums.phpfreaks.com/topic/146706-solved-count-not-working/
Share on other sites

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 :P

 

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.