No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
I have two tables that I need to get the following information but I can't seem to figure out how to structure the query: Table 1 type show max min Table 2 model height width depth In Table 1 I have the following for the first row (as an example): … | |
I have two tables that are the same. One stores info for the offense and a second for a defense. $sql = mysql_query("SELECT player FROM offense GROUP BY player UNION SELECT player FROM defense GROUP BY player"); while ($row = mysql_fetch_array($sql)) { $player = ($row['player']); echo "$player<br>"; } The problem … |