[SOLVED] Help with comment code

[steviez]

Hi,

 

on my site i have a comment box so users can send comments to one another. How can i make it so if there is a new comment a allert comes up in there account. All the info is stored in a database and unread comments are inserted with a read status or 0, then when read it turns to 1

 

Thanks

[Philip]

$query = "SELECT * FROM `comments` WHERE `userid`='".$userid."' && `read`='1'"

[steviez]

i need somthing to bring the alert up, like if there is comments in the database that are unread it will tell the users.

 

 

[Philip]

whoops, meant a 0 at read.

 

<?php
$query = "SELECT * FROM `comments` WHERE `userid`='".$userid."' && `read`='0'";
$select = mysql_query($query, $connection) or die(mysql_error());
$num_messages = mysql_num_rows($select);
if($num_messages > 0) {
echo "You have ".$num_messages." new messages!";
}
?>

 

Like that? If you want something live you need to go with AJAX, where if they get a message it will let them know without the user having to refresh the page

[steviez]

thanks for that but for some reason i cant get it to work :S

[Philip]

What errors come back?

[steviez]

none, thats the silly thing it just does nothing

[Philip]

<?php
$query = "SELECT * FROM `comments` WHERE `userid`='".$userid."' && `read`='0'";
// Make sure to change fields/variables to match up with yours
$select = mysql_query($query, $connection) or die(mysql_error());
$num_messages = mysql_num_rows($select);
if($num_messages > 0) {
echo "You have ".$num_messages." new messages!";
} else {
echo "No new messages!";
}
?>

 

Try that. Make sure you have something in the database with read=0

[steviez]

Works perfect, thank you so much