How do I query with a hypertext link?

[michlcamp]

I have a script that queries a real estate database for properties on specific lakes - when run within the script it might look like this:

$query="SELECT * FROM properties WHERE water='Bass Lake' ORDER BY price ASC";

how to I query using a link?
The link below doesn't work, but should it be something like this?:

[mysite.com...] Lake

[bibby]

hover over that link you posted...
quotes help.

a href=http://mysite.com/getlake.php?water='Bass Lake'

/// then , for a handler search for a water var

if ($water){
$query="SELECT * FROM properties WHERE water='$water' ORDER BY price ASC";}