MySQL invalid argument when using WHERE OR

Question

I can select everything from my db but i want to select everything that has a condition (which is a field in the table) of new or used but seemingly am doing something wrong:

$query = "SELECT * FROM caravandb WHERE condition='New' OR condition='Used' ORDER BY price DESC";

Anyone able to shed light on where i am going wrong?

$caravanquery = "SELECT * FROM caravandb WHERE condition = 'New' OR condition = 'Used' ORDER BY price DESC";
$caravanresult = mysql_query($caravanquery);
while($row = mysql_fetch_array($caravanresult)){
echo "<td width='280' align='center' class='model'>";
echo $row['make'] . " " . $row['model'] . " " . $row['year'];
echo "</td><td width='100'>";
echo "<ul>" . "<li>" . $row['berth'] . " Berth</li>" . "<li>MTPLM: " . $row['mtplm'] . "Kg</li>" . "</ul></td>";
echo "<td width='60' align='center' class='price'>";
echo "<span>" . $row['oldprice'] . "</span>" . "<br />&pound;" . substr($row['price'], 0, -3) . ',' . substr($row['price'], -3);
echo "</td><td width='200' align='right' class='layout'>";
echo "<img src='layouts/".$row['ref'].".gif'>";
echo "</td></tr>";
}

What happens when you run that query? Does it fail? Does it return the wrong data? — Ike Walker
– Ike Walker, Commented Aug 21, 2013 at 15:44
it fails: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource — John
– John, Commented Aug 21, 2013 at 15:45

Mihai · Accepted Answer · 2013-08-21 15:52:37Z

2

"SELECT * FROM caravandb WHERE `condition`='New' OR `condition`='Used' ORDER BY price DESC"

Condition is a reserved word.http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

answered Aug 21, 2013 at 15:52

Mihai

26.8k8 gold badges71 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL invalid argument when using WHERE OR

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related