question

[msnhockey]

hi,

this is a question regarding php coding.

i have 2 examples below.. will these work against each other or will they be fine if put on the same php page

$sql_scores_statement = "SELECT * FROM schedule_scores WHERE "

."(team1 = '$id' OR team2 = '$id') "

."AND season = '$sid' "

    ."AND team1_score > '-' "

."ORDER BY date DESC LIMIT 1";

and

$sql_scores_statement = mysql_query("SELECT * FROM schedule_scores WHERE "

    ."season = '$sid' "

."AND (team1 = $team2 AND team2 = $team1) OR (team1 = $team1 AND team2 = $team2) "


    ."AND team1_score > '-' "

    ."AND team2_score > '-' "

    ."ORDER BY date DESC LIMIT 5");

[gardnc]

If you plan to process each query independent of one another, i.e. read records from the first and process or print, and then do the next one it will be just fine. If the two need to work in conjunction with one another that can work as well as long as you use different record sets for each.