Exclude results from $sql1 from $sql2

[brrutzo]

Hello - I apologize if this has been covered in the past, I am having difficulty locating it if it has.

I have 2 queries. The first selects just one column of data

$sql1 = "SELECT schedule.teamid FROM schedule WHERE score1 =8";
$result = mysql_query($sql1);

What I would like to do is exclude the results from sql1 from sql2

$sql2 = "SELECT schedule . teamid , MAX(schedule . gameday )AS date , schedule . opponent , schedule . winloss , schedule . score1 , schedule . score2 , teams . id , teams . city , teams . schedulelink FROM schedule JOIN teams ON schedule . teamid =teams . id WHERE winloss IN ('L' , 'W' ) AND schedule.teamid <> ".$result."GROUP BY schedule . teamid ORDER BY `schedule` . `teamid` ASC LIMIT 0, 30"

As you can see above, I am attempting to exclude the results via an AND schedule.teamid <> ".$result."GROUP BY s.......

I really appreciate your help.

Thank you in advance

😕

[laserlight]

You cannot link two queries in that way. However, you can make use of the condition from the first query in the second query, e.g.,

$sql2 = "SELECT schedule.teamid, MAX(schedule.gameday) AS `date`,
                schedule.opponent, schedule.winloss, schedule.score1,
                schedule.score2, teams.id, teams.city, teams.schedulelink
         FROM schedule JOIN teams ON schedule.teamid=teams.id
         WHERE winloss IN('L', 'W') AND schedule.score1<>8
         GROUP BY schedule.teamid ORDER BY schedule.teamid ASC LIMIT 0, 30";

[brrutzo]

Thank you for your response laserlight. Unfortunately, that will not work for this situation. I actually did try to use that and I am familiar with JOINS.

The reason I feel that it doesn't work for this situation is I believe because of the MAX(date) syntax. I believe that will select the most recently played games <>teams that have scored 8. However, my goal is to eliminate teams that have scored a total of 8 runs based on a certain date (the date syntax was excluded from example to keep it simple) and then show the most recently played games for the remaining teams who have yet to score 8.

Again, thank you very much for your feedback. It is greatly appreciated!

[laserlight]

I suggest that you provide the relevant database schema and state what exactly you want to select.