Simple PM system

[Dysan]

Hi,

 

Using PHP, how would you go about creating a simple PM system, that every time the page loads, checks if any new messages have been sent, and navigates to a page upon finding new messages (e.g. http://www.google.co.uk)?

[dbillings]

like the forum your in now? hit refresh and new posts appear.

[l0ve2hat3]

use ajax

[graham23s]

or what i do is just set up a query to run on the particular page:

 

$q_pm = "SELECT * FROM `pms` WHERE `id`='$loggedin_users_id'";
$r_pm = mysql_query($q_pm);

if(mysql_num_rows() > 0)
{
print("You have a private message!");
}

 

there a good few ways to improve it though

 

hope it helps

 

Graham

[The Little Guy]

To expand on graham23s query:

<?php
$q_pm = "SELECT * FROM `pms` WHERE `id`='$loggedin_users_id' AND `viewed`='0'";
// 0 = unread
// 1 = read
// 2 = replied
$r_pm = mysql_query($q_pm);

if(mysql_num_rows() > 0)
{
print("You have a private message!");
}
?>