[RESOLVED] Variable in db query

[mikawhat]

if (isset($_POST["checkbox"])) {
$stat = available;

status = '$stat' OR '$stat' = ''

if the checkbox in my form is checked, this will use the value 'available' in my db query, else it will us the value ''.

Is it possible to give 2 values to $stat ? i want my query to search for 'available' and 'under construction' when the checkbox is checked.

[Oni]

I think that you change it to look like this:

$stat = "available";
I think that you can't give 2 values to a variable the way you're doing it atleast... Maybe if you create an array but I don't know anything about arrays as I don't use them 🙂

[samudasu]

if (isset($_POST["checkbox"])) {
    $stat = "'available' or status = 'under construction'";
} else {
    $stat = '';
}

$query = "select * from table where status = $stat";

[mikawhat]

Perfect! Thanx a lot!