Help with Query...

jbachris

I've looked at this query over and over and over and can't figure out what's wrong.

$past_matches_rs = $conn->Execute ( "SELECT REPLACE(team.team_name, ' ', '-') AS team_dashed, date_format(matches.match_date, '%m-%d-%Y')as matchdate, matches.match_id, matches.match_type, matches.match_location, matches.match_opponent, team.team_id, team.team_name, type_match.type_id, type_match.type_match_short FROM matches, team, type_match WHERE matches.match_date < CURDATE() AND matches.match_opponent=team.team_id AND matches.match_type=type_match.type_id AND matches.match_opponent=" . $next_rs->Fields("match_opponent") . " ORDER BY matches.match_date ASC" ) or die ( $conn->ErrorMsg() );

I'm getting this error:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY matches.match_date ASC' at line 1

Any ideas?

bradgrafelman

Instead of just executing that long string, try storing the query in a variable and echo()'ing it out. Visually inspect it - does it look wrong?

If not, post the echo'ed query here.

jbachris

bradgrafelman wrote:
Instead of just executing that long string, try storing the query in a variable and echo()'ing it out. Visually inspect it - does it look wrong?

If not, post the echo'ed query here.

I think the error is here:

matches.match_opponent=" . $next_rs->Fields("match_opponent") . "

I have another page I was putting together and used something similar, but it did not work either. If I were to store the " . $next_rs->Fields("match_opponent") . " in a variable then call it in the WHERE clause how would I do that?

I know how to store the variable, I'm just unsure of how to get it in the WHERE clause.

bradgrafelman

? How to get it in the WHERE clause? Just as you would any thing else, such as the object you tried...

matches.match_opponent=" . $variable . "