var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: MySQL "OR" Statement Question
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
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.
"SELECT * FROM hs_ajax_suggest WHERE hsName LIKE '".$param."%' OR hsCity LIKE '".$param."%' OR hsState LIKE '".$param."%' LIMIT 10")
Do you guys have any suggestions?
it's not really wrong
OR is a valid keyword -- it's a logical connector
that query is structured fine
"more relevant response" would need to be defined before i can comment on it