asked on SQL Query - return EXACT match on two parameters
What if I want to add a second parameter to my query? I understand the % but I want the both the $th and $sport vars (below) to be an exact match, not a "like"...
This works for one parameter, but needs to be modified to be EXACT EQUALS, not LIKE:
$sql="SELECT * FROM schedules WHERE team LIKE '%".$tm."%' ORDER BY date";
This is not working for two, how do I add the second parameter (they are both being passed in a URL string:
$sql="SELECT * FROM schedules WHERE team LIKE '%".$tm."%' AND sport='%".$sport."%'ORDER BY date";
This works for one parameter, but needs to be modified to be EXACT EQUALS, not LIKE:
$sql="SELECT * FROM schedules WHERE team LIKE '%".$tm."%' ORDER BY date";
This is not working for two, how do I add the second parameter (they are both being passed in a URL string:
$sql="SELECT * FROM schedules WHERE team LIKE '%".$tm."%' AND sport='%".$sport."%'ORDER BY date";
PHP
Last Comment
edavo
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
This is not working - I copied and pasted it in place and the code below appears broken (color coded) --- Something in this line is breaking the code...?
ASKER
Fast Service = Happy customer - you guys are GREAT!