IDK how to ....

[techiefreak05]

I'm creating a message system on my site, which works fine, but theres one thing, letting a user know they have new messages!  I think i'd use this somewhere...
[code]SELECT * FROM `messages` WHERE `to` = '$to' AND `status` = 'no'[/code]

the variable "$to" will be defined, it will be $to = '$_SESSION[username]'

I want to echo "New Messages" if anywhere in the "status" column equals "no" , how would I do this?

[desithugg]

[code]
$result = mysql_query("SELECT count(*) FROM `messages` WHERE `to` = '$to' AND `status` = 'no'");
if (!$result) {
  echo 'Could not run query: ' . mysql_error();
  exit;
}
$row = mysql_fetch_row($result);
$new = $row[0];
if($new == "")
{
$new = "0";
}
if(new != "0" )
{
echo "You have $new new messages.";
}
[/code]
umm try this

[Jeremysr]

Use [url=http://ca3.php.net/manual/en/function.msql-num-rows.php]mysql_num_rows[/url]() to find out how many new messages they have. If they have more than 0 new messages, display the New Messages link.

[techiefreak05]

I used this
[code]$to = '$_SESSION[username]'
$result = mysql_query("SELECT count(*) FROM `messages` WHERE `to` = '$to' AND `status` = 'no'");
if (!$result) {
  echo 'Could not run query: ' . mysql_error();
  exit;
}
$row = mysql_fetch_row($result);
$new = $row[0];
if($new == "")
{
$new = "0";
}
if(new != "0" )
{
echo "<font color=red><b>You have $new new messages!</b></font>";
}[/code]

and got this error:
[code]Parse error: syntax error, unexpected T_VARIABLE in /home/zyco/public_html/newlayout/main.php on line 32[/code]

[Jeremysr]

You're missing a semi-colon on the first line in your code that you showed above.

[techiefreak05]

I aded the semicolon onto [code]$to = '$_SESSION[username]'[/code] and now i get this error:
[code]Parse error: syntax error, unexpected T_IS_NOT_EQUAL, expecting T_STRING or T_VARIABLE or '$' in /home/zyco/public_html/newlayout/main.php on line 43[/code]

[Jeremysr]

Well which line is line 43? BTW you don't put quotes when your assigning a variable to another variable like that.

$to = $_SESSION[username];

[techiefreak05]

here is LINES 27 - 47(the whole PHP script)

[code]  <?php
if($logged_in){
headerLinks();
$to = '$_SESSION[username]';
$result = mysql_query("SELECT count(*) FROM `messages` WHERE `to` = '$to' AND `status` = 'no'");
if (!$result) {
  echo 'Could not run query: ' . mysql_error();
  exit;
}
$row = mysql_fetch_row($result);
$new = $row[0];
if($new == "")
{
$new = "0";
}
if(new != "0" )
(43){
echo "<font color=red><b>You have $new new messages!</b></font>";
}
}
?>[/code]

[desithugg]

remove the
$to = '$_SESSION[username]';
quotes
make it
$to = $_SESSION['username']; thats where i think the error is thats all i can see o my bad i see ur
and ur missing

o sorry i mis read it instead of doing
if($logged_in){
and than } at the end
try
if(!$logged_in){
echo"please login";
exit;
}

[techiefreak05]

I still get the same error:
[code]Parse error: syntax error, unexpected T_IS_NOT_EQUAL, expecting T_STRING or T_VARIABLE or '$' in /home/zyco/public_html/newlayout/main.php on line 41[/code]

with this as my updated code:
[code]  <?php
if($logged_in){
headerLinks();
$to = $_SESSION[username];
$result = mysql_query("SELECT count(*) FROM `messages` WHERE `to` = '$to' AND `status` = 'no'");
if (!$result) {
  echo 'Could not run query: ' . mysql_error();
  exit;
}
$row = mysql_fetch_row($result);
$new = $row[0];
if($new = ""){
$new = "0";
}
if(new != "0" ){
echo "<font color=red><b>You have $new new messages!</b></font>";
}
}
?>[/code]

LINE 41 IS:
[code]if(new != "0" ){[/code]

[desithugg]

i dont see any error on that line try updating the code to this
[code]
<?php
if(!$logged_in){
echo"Please Log-in";
exit;
}
headerLinks();
$to = $_SESSION['username'];
$result = mysql_query("SELECT count(*) FROM `messages` WHERE `to` = '$to' AND `status` = 'no'");
if (!$result) {
   echo 'Could not run query: ' . mysql_error();
   exit;
}
$row = mysql_fetch_row($result);
$new = $row[0];
if($new = ""){
$new = "0";
}
if(new != "0"){
echo "<font color='red'><b>You have $new new messages!</b></font>";
}
?>
[/code]
im pretty sure this will work

[techiefreak05]

ok, i got the problem fixed.. wanna hear the solution, your gonna beat yourself... look, whats wrong with this:
[code]if(new != "0"){[/code]

it SHOULD be
[code]if($new != "0"){[/code]

haha now go kick yourself :P lmao!