A little help

[Helinxed]

Hello brows,I'd like a little help.

I'm making a web online game,then in the Map system.

I need get coords of players that is around.

Get in Database something like that:

<?php
$result = mysql_query("select * from mapa where x_coord > '5' AND x_coord < '10'");
while($row = mysql_fetch_array($result)) {
?>

But dosen't work cuz don't accept the ">" OR "<".

I know,I'd can create a

IF($row['x_coord'] > 5 OR $row['x_coord'] < 10) {

But if there's many players,it would give a sucking LAG =/

Someone have another idea?Thanks =)

[simplypixie]

Have you tried running the select statement directly in your database to see if you get an error at database level (always my first point of testing)?

I'm a bit confused as to why you want to use OR in this case as it would return all records. AND seems to be the most appropriate operator. You can also try the BETWEEN keyword. If your data is integer, you don't need the single quotes in the SQL.