MySQL Query Question

[Thanol]

How do you WHERE 2 things?

Like I want to do:

$draw_rows = "SELECT * FROM $dbtable WHERE $theme, $color LIMIT $start,$number_pp";
$result = mysql_query($draw_rows);
while($row = mysql_fetch_array($result)) //line 51
{ 
     echo "stuff";
}

But MySQL keeps saying that: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /../view-backgrounds.php on line 51;

[Pulse]

$draw_rows = "SELECT * FROM $dbtable WHERE $theme, $color LIMIT $start,$number_pp";
$result = mysql_query($draw_rows);
while($row = mysql_fetch_array($result)) //line 51
{
echo "stuff";
}

Do me a fav, execute a print $draw_rows after you've set it so one can see what the end SQL statement looks like that way one can see if a variable has no value or what exactly is wrong, cause we do not know the values of $dbTable, $theme and $color ...

print $draw_rows;

[Thanol]

Originally Posted by Pulse

Do me a fav, execute a print $draw_rows after you've set it so one can see what the end SQL statement looks like that way one can see if a variable has no value or what exactly is wrong, cause we do not know the values of $dbTable, $theme and $color ...

Sure:
$draw_rows = "SELECT * FROM scott WHERE theme='animals', color='blue' LIMIT 0,15";

[Eran-s]

Use "AND" instead of ",".

[Thanol]

Originally Posted by Eran-s

Use "AND" instead of ",".

Thanks! That's all I needed.

[Eran-s]

Originally Posted by Thanol

Thanks! That's all I needed.

No problem

[Pulse]

cool fixed