Page 1 of 1

Would this query be correct?

Posted: Thu Mar 31, 2005 6:14 pm
by anthony88guy
Can you use less/greater then or equal to in your query?

Posted: Thu Mar 31, 2005 6:21 pm
by infolock

Posted: Thu Mar 31, 2005 8:53 pm
by John Cartwright

Code: Select all

mysql_query("SELECT * FROM farms WHERE defenceaction <= '$fdefenceaction' && armysize >= '$farmysize'") or die(mysql_error());
I believe && is not valid in mysql, use AND.