ohnder
11-20-2005, 10:09 PM
How do I merge this SELECT form?
$grab_totals = "SELECT idh as idt, SUM(w) as w, SUM(d) as d, SUM(l) as l, SUM(gf) as gf, SUM(ga) as ga FROM soccer
WHERE idh LIKE 'nor' AND ida LIKE 'swe' GROUP BY idt" AND
"SELECT ida as idt, SUM(l) as w, SUM(d) as d, SUM(w) as l, SUM(ga) as gf, SUM(gf) as ga FROM soccer
WHERE ida LIKE 'nor' AND idh LIKE 'swe' GROUP BY idt";
$result = @mysql_query($grab_totals);
sql_query("$result", "$error_messages[04]");
$grab_totals = "SELECT idh as idt, SUM(w) as w, SUM(d) as d, SUM(l) as l, SUM(gf) as gf, SUM(ga) as ga FROM soccer
WHERE idh LIKE 'nor' AND ida LIKE 'swe' GROUP BY idt" AND
"SELECT ida as idt, SUM(l) as w, SUM(d) as d, SUM(w) as l, SUM(ga) as gf, SUM(gf) as ga FROM soccer
WHERE ida LIKE 'nor' AND idh LIKE 'swe' GROUP BY idt";
$result = @mysql_query($grab_totals);
sql_query("$result", "$error_messages[04]");