Hey there,
I'm working on a script that selects a list of schools, and displays them according to the user's specified criteria.
Here's the query I'm using at the moment
Quote:
|
"SELECT * FROM hs_ajax_suggest WHERE hsName LIKE '".$param."%' OR hsCity LIKE '".$param."%' OR hsState LIKE '".$param."%' LIMIT 10")
|
This seems really wrong to me. I don't even know if "OR" is a valid statement. I'd like to know how to get a more structured query, and a more relevant response from this query.
Do you guys have any suggestions?
Thanks