Trying to get tinyint value from mysql

[newuser666]

The database (mysql) has field "complete" in a table. it is set to
tinyint(1), null=no, default=0.
1 and 0 are the only possible values.
If trying to print out a report.
All i want is if complete=1 print "Closed" else print "Open"

Here's the code i'm using but with no luck

if ($task[complete] ="1")
{$status=Complete;}
else
{$status=Open;}

The output is always "complete"

What am i doing wrong? Plz help. thx.

[pjo]

The problem you are facing is that the conditional expression is assigning the value "1" to $task[complete], the result is that it always evaluates to true. You need to use double equals signs (==) to test for equality. Try this piece of code instead:

if ($task['complete'] =="1") {
$status = "Complete";
}
else {
$status = "Open";
}

compare with:

if ($task[complete] ="1")
{$status=Complete;}
else
{$status=Open;}

Hope this helps. 🙂