Why won't this work.

[justAnoob]

The echo messages explains what I'm trying to do. Why are the simple things so difficult for me.... I think I over think them.

<?php
error_reporting(E_ALL);
ini_set('display_errors',1);
include "connection.php";
$krazycool = $_SESSION['id'];
$sql='SELECT id FROM member_messages WHERE user_id = "$krazycool" and status = "NEW"';
$result=mysql_query($sql);
$count=mysql_num_rows($result);
if($count >= 1)
{
     echo "You have " . $count . " new messages.";
}
mysql_close();
?>

[Maq]

Switch your single and double quotes around, your variable isn't being interpolated.

 

$sql="SELECT id FROM member_messages WHERE user_id = '$krazycool' and status ='NEW'";

[justAnoob]

i echoed out both variables,,, $count and $krazycool.... my count keeps coming back as 0... I know that there is 1 new message in the inbox.... in mysql table the column called status keeps the record called "NEW" in it if the message is new... So what is going on?

<?php  // it is not reading the status column correctly for some reason
$sql="SELECT id FROM member_messages WHERE user_id = '$krazycool' and status = 'NEW'";
?>

[roopurt18]

Why are the simple things so difficult for me

 

Programming is all in the details!

[Ken2k7]

What would this output?

 

<?php
include "connection.php";
$sql = 'SELECT status FROM member_messages LIMIT 5;';
$results = mysql_query($sql);
while ($row = mysql_fetch_assoc($results)) {
     var_dump($row['status']);
     echo "\n";
}

[justAnoob]

string(3) "NEW" string(0) ""    is what is says....

 

I checked mysql and right now I have 2 messages in my table,, and one of them is marked as NEW

[Ken2k7]

What about this?

<?php
session_start();
include "connection.php";
$krazycool = intval($_SESSION['id']);
$sql="SELECT COUNT(*) as count FROM member_messages WHERE user_id = '$krazycool' WHERE status='NEW'";
$result=mysql_query($sql);
if($row = mysql_fetch_assoc($result)) var_dump($row['count']);
else echo 'no results';
mysql_close();

[justAnoob]

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource on line 271

no results

[Ken2k7]

Uh... there must be a SQL error.

 

<?php
session_start();
include "connection.php";
$krazycool = intval($_SESSION['id']);
$sql="SELECT COUNT(*) as count FROM member_messages WHERE user_id = '$krazycool' WHERE status='NEW'";
$result=mysql_query($sql) or die(mysql_error());
if($row = mysql_fetch_assoc($result)) var_dump($row['count']);
else echo 'no results';
mysql_close();

[justAnoob]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE status='NEW'' at line 1

[Ken2k7]

Ah I am stupid!

 

<?php
session_start();
include "connection.php";
$krazycool = intval($_SESSION['id']);
$sql="SELECT COUNT(*) as count FROM member_messages WHERE user_id = '$krazycool' AND status='NEW'";
$result=mysql_query($sql) or die(mysql_error());
if($row = mysql_fetch_assoc($result)) var_dump($row['count']);
else echo 'no results';
mysql_close();

 

Sorry justAnoob.

[justAnoob]

lol,, that is the change that I made also.. give me a couple minutes.

[justAnoob]

////////////// this is what I get now    string(1) "0"

 

<?php
session_start();
include "connection.php";
$krazycool = intval($_SESSION['id']);
$sql="SELECT COUNT(*) as count FROM member_messages WHERE user_id = '$krazycool' AND status='NEW'";
$result=mysql_query($sql) or die(mysql_error());
if($row = mysql_fetch_assoc($result))
{
   var_dump($row['count']);
}
else
{
   echo 'no results';
}
mysql_close();

?>

[justAnoob]

I put it back the way you had it and the result is the same from what I last posted... How does yours work without the curly brackets? I though you needed them.

<?php
session_start();
include "connection.php";
$krazycool = intval($_SESSION['id']);
$sql="SELECT COUNT(*) as count FROM member_messages WHERE user_id = '$krazycool' AND status='NEW'";
$result=mysql_query($sql) or die(mysql_error());
if($row = mysql_fetch_assoc($result)) var_dump($row['count']);  // no curly's around var_dump????
else echo 'no results';  //no curly brackets around the echo ???
mysql_close();
?>

[Ken2k7]

You don't need the curly braces if it's a one liner, which mine is. If you want to perform multiple lines of codes after them, then you need the curly braces. You also don't need the ending ?> if it's at the end of the script.

 

<?php
session_start();
include "connection.php";
$krazycool = intval($_SESSION['id']);
$sql="SELECT COUNT(*) as count FROM member_messages WHERE user_id = '$krazycool'";
var_dump($sql);
$result=mysql_query($sql) or die(mysql_error());
if($row = mysql_fetch_assoc($result)) var_dump($row['count']);
else echo 'no results';
mysql_close();

[fullyscintilla]

but is good programming habit to just always use them..

[justAnoob]

string(65) "SELECT COUNT(*) as count FROM member_messages WHERE user_id = '0'" string(1) "0"

[justAnoob]

crap,, i messed up,, session id is the username not the id of the username

[justAnoob]

Ok,,, this is what I got now,, and it keeps returning a "1",,, when I know that now I have "2" NEW messages.

<?php
session_start();
include "connection.php";
$krazycool = intval($_SESSION['id']);
$sql_1="SELECT id FROM members WHERE username = '$krazycool'";
$result_1=mysql_query($sql_1) or die(mysql_error());
$go_cavs = $result_1;

$sql="SELECT COUNT(*) as count FROM member_messages WHERE user_id = '$go_cavs'";
$result=mysql_query($sql) or die(mysql_error());
$count = mysql_num_rows($result);
if($count >= 1) 
{
   echo $count;
}
else
{ 
   echo "Not yet.";
}
mysql_close();
	?>

[Ken2k7]

<?php
session_start();
include "connection.php";
$id = intval($_SESSION['id']);
$sql="SELECT COUNT(*) AS count FROM members WHERE username = '$id' AND status = 'NEW'";
$result=mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_row($result)) {
     echo $row['count'] . "\n";
}

[justAnoob]

did you get my last post where i said i messed up.. I'm working with 2 tables

[Ken2k7]

Oooh oops!

 

<?php
session_start();
include "connection.php";
$id = intval($_SESSION['id']);
$sql="SELECT COUNT(*) AS count FROM members m INNER JOIN member_messages mm ON (m.id = mm.user_id AND mm.status = 'NEW') WHERE m.username = '$id' LIMIT 1;";
$result=mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_row($result)) {
     echo $row['count'] . "\n";
}

[justAnoob]

Wow,, that is a new one for me,, never seen anything like that before. I'll give it a shot.. Could you explain what that does,, I mean I get the idea,, but what the characters mean (m)

[Ken2k7]

m and mm are aliases. I could have used anything I want really, except a column name (I think) or a mysql reserved word.

[justAnoob]

Will you be on tomorrow?,, maybe so we can figure this out.. Need to put my kid to sleep.