[SOLVED] counting received messages ?

[runnerjp]

currently i have my code like this

 

<?php
session_start();
include '../settings.php';
$user= get_username($_SESSION['user_id']);
$query = "SELECT received FROM messages WHERE reciever = '$user' and received = '1' "; 
if ($result = mysql_query($query)){
    if (mysql_num_rows($result)) {
        $array = mysql_fetch_assoc($result);
        $messages = 

echo $messages;
}
}
?>

but im not sure how i would count the number of messages recieved = 1 and display the number

 

 

[Daniel0]

Try

SELECT COUNT(*) AS received FROM messages WHERE receiver = '$user' AND received = 1;

[runnerjp]

what would i echo ?

[Daniel0]

$query = "SELECT COUNT(*) AS received FROM messages WHERE receiver = '$user' AND received = 1"; 
if (($result = mysql_query($query)) && mysql_num_rows($result)){
    $data = mysql_fetch_assoc($result);
    echo $data['received'];
}

[runnerjp]

i echoed my query and its correct but its displaying no results

[runnerjp]

sorry i spelt somethign wrong doh lol ty that works great

[runnerjp]

ok did a bit of editing

 

<?
session_start();
include '../settings.php';
$user= get_username($_SESSION['user_id']);
$query = "SELECT COUNT(*) AS recieved FROM messages WHERE reciever = '$user' AND recieved = 1";
if (($result = mysql_query($query)) && mysql_num_rows($result)){
    $data = mysql_fetch_assoc($result);
$messages = $data['recieved'];
if($data['recieved'] < 1)
                {
                echo "you have $messages  message";
                }
            
            //There are no errors so far which means the form is completely filled out    
            else
                {
    echo 'no messages';
}
}
?>

 

have i done if($data['recieved'] < 1) right as it give me 0 even though i have 2 messages

[trq]

That code will echo 'you have 0 message' if you have no messages and 'no messages' if you have some.

[runnerjp]

humm but i swapped it around

 

<?
session_start();
include '../settings.php';
$user= get_username($_SESSION['user_id']);
$query = "SELECT COUNT(*) AS recieved FROM messages WHERE reciever = '$user' AND recieved = 1";
if (($result = mysql_query($query)) && mysql_num_rows($result)){
    $data = mysql_fetch_assoc($result);
$messages = $data['recieved'];
if($data['recieved'] < 1)
                {
echo 'no messages';
                
                }    
            
            else
                {
    echo "you have $messages  message";
}
}
?>

 

and i get you have no messages lol  still even tho i have 2!

[runnerjp]

intrestingly i did this again..

 

<?$query = "SELECT COUNT(*) AS recieved FROM messages WHERE reciever = 'Admin' AND recieved = 1"; 
if (($result = mysql_query($query)) && mysql_num_rows($result)){
    $data = mysql_fetch_assoc($result);
    echo $data['recieved'];
}?>

 

and it also shows 0  so this is the problem....

 

if only 1 colum in my db is set to 1 it shows 1 if more then 1 it shows 0 :S

[trq]

Just noticed you already have a field names 'recieved', you'll need to change the alias to something else.

 

<?php

session_start();
include '../settings.php';
$user= get_username($_SESSION['user_id']);
$query = "SELECT COUNT(*) AS c FROM messages WHERE reciever = '$user' AND recieved = 1";
if (($result = mysql_query($query)) && mysql_num_rows($result)){
  $data = mysql_fetch_assoc($result);
  $messages = $data['c'];
  if ($data['recieved'] < 1) {
    echo 'no messages';
  } else {
    echo "you have $messages  message";
  }
}

?>

[runnerjp]

but that echos no messages even tho still there are 2 lol

[jonsjava]

he forgot to change a variable:

<?php

session_start();
include '../settings.php';
$user= get_username($_SESSION['user_id']);
$query = "SELECT COUNT(*) AS c FROM messages WHERE reciever = '$user' AND recieved = 1";
if (($result = mysql_query($query)) && mysql_num_rows($result)){
  $data = mysql_fetch_assoc($result);
  $messages = $data['c'];
  if ($data['c'] < 1) {
    echo 'no messages';
  } else {
    echo "you have $messages  message";
  }
}

?>

[runnerjp]

humm no that still does not work i just keep getting no messages

[jonsjava]

this is just a test script, to see what you get:

<?php
session_start();
include '../settings.php';
$user= get_username($_SESSION['user_id']);
$query = "SELECT COUNT(*) AS c FROM messages WHERE reciever = '$user' AND recieved = 1";
if (($result = mysql_query($query)) && mysql_num_rows($result)){
  $data = mysql_fetch_assoc($result);
  $messages = $data['c'];
  print $messages;
  exit();
  if ($data['c'] < 1) {
    echo 'no messages';
  } 
  else {
    echo "you have $messages  message";
  }
}

?>

[jonsjava]

posting again. having 666 as my post count creaped me out

[runnerjp]

ok update it says 1 message if i have 1 message but if i have more then 1 it says no messages

 

 

Full Texts  	id 	reciever 	sender 	subject 	message 	recieved 	time
Edit 	Delete 	2 	  Admin 	Admin 	test 	test 	                           1 	1212507884
Edit 	Delete 	4 	Admin 	Admin 	testing 	hey 	                          1 	1212507884

 

thats what my table looks like

 

 

edit :  what you sent me it outputted 0

[jonsjava]

what does this script do for you (I know it's a step backwards, but....)

<?php

session_start();
include '../settings.php';
$user= get_username($_SESSION['user_id']);
$query = "SELECT * FROM messages WHERE reciever = '$user' AND recieved = 1";
$result = mysql_query($query);
$no_of_msgs = mysql_num_rows($result);
if ($no_of_msgs > 0){
  $data = mysql_fetch_assoc($result);
  echo "you have $no_of_msgs  message";
}

?>

[runnerjp]

gives me a blank page

[jonsjava]

slightly modified version (forgot the else)

<?php

session_start();
include '../settings.php';
$user= get_username($_SESSION['user_id']);
$query = "SELECT * FROM messages WHERE reciever = '$user' AND recieved = 1";
$result = mysql_query($query);
$no_of_msgs = mysql_num_rows($result);
if ($no_of_msgs != 0){
  $data = mysql_fetch_assoc($result);
  echo "you have $no_of_msgs  message";
}
else{
print "No messages found";
}
?>

[runnerjp]

i get no messages found

[fanfavorite]

Just a note received is spelt wrong in the query, so please make sure it is spelt wrong in your database.  Also, your query was looking for recieved = 1, so if it was more than 1, it would not return a result.  I have changed it to != 0.  Give this a try: 

 

<?php

 

session_start();

include '../settings.php';

$user= get_username($_SESSION['user_id']);

$query = "SELECT * FROM messages WHERE reciever = '$user' AND recieved != 0";

$result = mysql_query($query);

$no_of_msgs = mysql_num_rows($result);

if ($no_of_msgs != 0){

  $data = mysql_fetch_assoc($result);

  echo "you have $no_of_msgs  message";

}

else{

print "No messages found";

}

?>

[jonsjava]

If fanfavorite's advice doesn't help, and you get the same result, that usually means that it's returnig a "0" on the num_rows result.  Not much we can do besides have you print out the query you are running:

<?php

session_start();
include '../settings.php';
$user= get_username($_SESSION['user_id']);
$query = "SELECT * FROM messages WHERE reciever = '$user' AND recieved = 1";
print $query;
exit();

when you run that, do you get the expected user in the $user field?

[runnerjp]

ahh fans idea worked... i didnt take into fact that it =1 would mean only 1 result...

 

thanks for sticking with me through this 1 and really drilling to get the idea.. learned alot!!

 

i would like to know so i undertsand it fully the use of != 0

[fanfavorite]

!= means NOT EQUAL TO.  Which means that if recieved equals anything other than 0, it will return true.  With recieved = 1, it would only return true if there was 1 message.

 

I hope I didn't confuse you are all.