[SOLVED] Detect new messages for inbox

[mmarif4u]

Hi everyone.

 

I have a PMS for my users within my site.

I want to run a query that will detect that a specific user who are login to the site,

has how many new messages...

How to perfrom this query:

Like:

$sql = "select * from pms where to_id = '$nruser1' AND opened ='no' ";
$result = mysql_query($sql);
$row = mysql_num_rows($result);
Echo "You have $row new messages.";

 

 

Any help will appreciated.

Thanks in advance.

[trq]

I want to run a query that will detect that a specific user who are login to the site,

has how many new messages...

 

Pardon?

[fert]

$sql = "SELECT COUNT(*) as new FROM pms WHERE to_id = '$nruser1' AND opened ='no' ";
$result = mysql_query($sql);
$row=mysql_fetch_array($result);
$num=$row['num'];
echo "you have {$num} new messages";

[mmarif4u]

@ thorpe

PMS mean private messaging system just like the phpfreaks are using.

When some some body have new message from other member, when he go to his inbox there a

small line that "you have 2 new messages"

 

@fert

thanks for ur query i will try it.

[pocobueno1388]

Fert - Where did this come from?

$num=$row['num'];

 

I don't understand where you pulled $row['num'] from.

 

<?php

$sql = "select * from pms where to_id = '$nruser1' AND opened ='no' ";
$result = mysql_query($sql);
$num = mysql_num_rows($result);

if ($num > 0){
   echo "You have $num new messages!";
}

?>

[fert]

sorry I meant

$sql = "SELECT COUNT(*) AS new FROM pms WHERE to_id = '$nruser1' AND opened ='no' ";
$result = mysql_query($sql);
$row=mysql_fetch_array($result);
$new=$row['new'];
echo "you have {$new} new messages";

[mmarif4u]

@ pocobueno1388...

 

Fert - Where did this come from?

$num=$row['num'];

 

I don't understand where you pulled $row['num'] from.

 

<?php

$sql = "select * from pms where to_id = '$nruser1' AND opened ='no' ";
$result = mysql_query($sql);
$num = mysql_num_rows($result);

if ($num > 0){
   echo "You have $num new messages!";
}

?>

 

Thanks pocobueno1388...

So it means that ur query will echo if they new message if no new message then nothing

to show to the user...

OHHH

Yeh also this, my mind is dull this time:

if ($num > 0){
   echo "You have $num new messages!";
}esle
{ echo "You have 0 messages!";
}

 

I think this will work.

Am i right

 

@ fert

 

Thanks fert for ur correction.

 

I will try both, hope both will work.

 

[pocobueno1388]

Oh, I thought you just wanted to show <b>new</b> messages, take out this code:

 

if ($num > 0){
   echo "You have $num new messages!";
}esle
{ echo "You have 0 messages!";
}

 

and this should be your final:

<?php

$sql = "select * from pms where to_id = '$nruser1' AND opened ='no' ";
$result = mysql_query($sql);
$num = mysql_num_rows($result);

echo "You have $num new messages!";

?>

 

 

[mmarif4u]

Oh, I thought you just wanted to show <b>new</b> messages, take out this code:

 

if ($num > 0){
   echo "You have $num new messages!";
}esle
{ echo "You have 0 messages!";
}

 

and this should be your final:

<?php

$sql = "select * from pms where to_id = '$nruser1' AND opened ='no' ";
$result = mysql_query($sql);
$num = mysql_num_rows($result);

echo "You have $num new messages!";

?>

 

 

 

I think ur final code is same to my 1st post query, which did not work.

Am i right...

[pocobueno1388]

Hmmm, I guess that is the same thing you did...I wonder why it isn't working. First of all, did any of the suggested methods work for you?

 

If nothing has worked yet, try adding this to your query result:

$num = mysql_num_rows($result)or die(mysql_error());

 

I couldn't think of a way it wouldn't work unless you just queried the database wrong.

[mmarif4u]

Yes u r right i also wondered, when it does not work bcoz i am not so bad in php.

That query just return the total number of messages for that user who

is looged in .

For example if he has 5 messages that code will show him

"You have 5 new messages". And that time he has no new msg  in the db.

 

Other:

I did not test the other queries yet bcoz i am far from my pc.

I will try that may be that will work.

 

Ok i will post either it works or not.

Thanks again for ur help.

 

 

[mmarif4u]

Hi guys again

That one which i make and the others one which u prople post, all works.

 

I dont know why last nite it doesnot work.(which i make[now working])

 

Thanks again for ur time.