MySQL Query Help

[mascali]

Hi, is it possible to have a query somthing like this:

select * from members where 'this_row' is less than $this_variable and more than $that_variable and 'this_other_row' is lass than $this_other_variable and more than $that_other_variable

Can somebody please turn this into a real query, or if thats impossible, can you join it up with PHP and so i have somthing that returns the same result.

Cheers,

Sean Mascali

[Dan Grossman]

$sql = "SELECT * FROM members WHERE col1 < $this_variable AND col2 < $that_variable AND (col3 < $this_other_variable AND col3 > $that_other_variable)";

// 

[mascali]

Thanks,

I tried to change it a bit and its not working properly, can you help me correct this please.

$query = "SELECT * FROM members WHERE trade LIKE $trimmed AND (user_pc_lat < $maxlat AND user_pc_lat > $minlat) AND (user_pc_lon < $maxlon AND user_pc_lon > $minlon) order by trade";

Thanks,

Sean

[Dan Grossman]

Use single quotes around $trimmed since it's a string type column (as opposed to numeric):

$query = "SELECT * FROM members WHERE trade LIKE '$trimmed' AND (user_pc_lat < $maxlat AND user_pc_lat > $minlat) AND (user_pc_lon < $maxlon AND user_pc_lon > $minlon) order by trade"; 

If you're trying to retrieve rows where trade is equal to $trimmed, just use =

$query = "SELECT * FROM members WHERE trade = '$trimmed' AND (user_pc_lat < $maxlat AND user_pc_lat > $minlat) AND (user_pc_lon < $maxlon AND user_pc_lon > $minlon) order by trade"; 

If your intent using LIKE was to match anything with $trimmed inside the trade column, % is the wildcard character in SQL:

$query = "SELECT * FROM members WHERE trade LIKE '%$trimmed%' AND (user_pc_lat < $maxlat AND user_pc_lat > $minlat) AND (user_pc_lon < $maxlon AND user_pc_lon > $minlon) order by trade"; 

To find out where the problem is when a query fails, print mysql_error():

$result = mysql_query($query, $connection) or die("An error occurred executing $query: " . mysql_error()); 

[mascali]

Yes it works now, thank you.