[Resolved] Extending SQLQuery

[gvanaco]

Can someone help me how I have to extend complex querys

$querymasnear = "SELECT massief_id, land_id, massief_naam FROM massieven WHERE massief_x BETWEEN $massief_x_min AND $massief_x_max, AND massief_y BETWEEN $massief_y_min AND $massief_y_max "

This is it. It's working very nice when I se only one Where funtion (between).
When I would use the and funtion its not working anymore.

It have to be in a range x between x-min, x-max and y between y-min and y-max.

Thats all.

The guide is so complex (s extending examples.

Thanks

[gvanaco]

you can use () <-- this things

$querymasnear = "SELECT massief_id, land_id, massief_naam FROM massieven WHERE (massief_x BETWEEN $massief_x_min AND $massief_x_max) AND (massief_y BETWEEN $massief_y_min AND $massief_y_max) "

Thanks for the solution