[RESOLVED] if statements

[Smackie]

I hate doing if statements and i ran into a if problem i need help with..

now in database i have a field named lock now its enum(0,1) 0 means unlock 1 means locked

here is the code i have i know its wrong lol i need some help.. usually i stay away from if statements but this is one of them times i can't get around it..

<?php

$sql = mysql_query("SELECT lock FROM forum_question");
while ($row = mysql_fetch_array($sql)) { 

if (!$lock && $row['lock'] == '0') { 

$new = true; 

echo "You may Post "; 

  } else {
               echo "Sorry this post is locked";
}
}
?>

can someone help me set this right?

Thank you
Smackie

[NogDog]

It's tough to help without knowing the exact logic you want to impose. Right now, your if condition is executing only if the value of $lock evaluates as false (FALSE, 0, '', unset) and $row['lock'] evaluates as '0' (which will also match 0, FALSE, '', or unset). Is that what you want, or do you want it to execute if either condition matches? In that case, use "||" instead of "&&".

[Smackie]

NogDog wrote:

It's tough to help without knowing the exact logic you want to impose. Right now, your if condition is executing only if the value of $lock evaluates as false (FALSE, 0, '', unset) and $row['lock'] evaluates as '0' (which will also match 0, FALSE, '', or unset). Is that what you want, or do you want it to execute if either condition matches? In that case, use "||" instead of "&&".

I'm not sure if i fully understand you :queasy: but i want it so if the field in database is set to 0 then users can posts, but if the field is set to 1 user's can't post.. btw this is a forum..

[NogDog]

From that description, it would seem there is no need for the !$lock && portion of the if condition.

[Smackie]

ok but i come up with an error..

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

[NogDog]

That means your query could not be parsed by MySQL. Try getting some debug info:

$sql = mysql_query("SELECT lock FROM forum_question");
if(!$sql)
{
   die("Query failed: " . mysql_error());
}

[Smackie]

Query failed: 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 'lock FROM forum_question' at line 1

that is what im geting 😕

[Smackie]

:o 😃 :o i figured it out lol i was a dummy there lol but thanx for helping..

Smackie