[RESOLVED] if.. Only in my dreams!

[zTagged]

What I'm trying to do is (Using Sessions), once a user has logged in, have it echo something according to what's in their 'status' column.

//Selects the user from the database according to their login name
$sqlquery = "SELECT * from table WHERE id=('".$_SESSION['SESS_MEMBER_ID']."')";

//brings up the selected user
$results = mysql_query($sqlquery) or die(mysql_error());

// Checks to see which value for 'status' is equal

if ($status='1')
{echo "You have one foo";}
if ($status='2')
{echo "You have two foo.";}
if ($status='3')
{echo "You have two foo and a bar.";}

What it does, is echo every variable. "You have one fooYou have two foo.You have two foo and a bar." is what I get.

Oh great PHP overlords, what am I doing wrong? :queasy:

[zTagged]

Okay, so I went back and tried it a bit different, same result. 😕

//brings up the selected user
$result = mysql_query($sqlquery) or die(mysql_error());
while($row = mysql_fetch_array($result))
{

// Checks to see which value for 'status' is equal

if ($row['status']='1')
{echo "You have one foo.";}
if ($row['status']='2')
{echo "You have two foo.";}
if ($row['status']='3')
{echo "You have two foo and a bar.";}}

[YAOMK]

You need to show us where $status is being assigned its value and whether it is part of an array or a simple variable.

At a glance in your if statements you are assigning $row['status'] the values 1, 2, 3, you need to use "==" instead of "=" as what you are trying to do is a comparison by means of the equality operator, not assign your variable those values.

[zTagged]

YAOMK wrote:

You need to show us where $status is being assigned its value. At a glance in your if statements you are assigning them the values, you need to use "==" instead of "=" as what you are trying to do is compare, not assign.

$status is assigned in my SQL table, and what I'm trying to do is if a user has a status code of 1 , have it echo "You have one foo."

[YAOMK]

When I posted my reply, your second post had just been inserted. I took a closer look and realized your while statement. Fix the equality operator.

[zTagged]

YAOMK wrote:

I took a closer look and realized your while statement. Fix the equality operator.

Bingo. That fixed it!