182x Posted July 28, 2007 Share Posted July 28, 2007 Hey guys, I have two different and unrelated tables and I have done a query to extract infor mation from it and I also have preformed a query to extract information from another table. I was wondering using PHP and my sql is it possible to perform some form of check so that if the year in table1 equals 2007 and the count is 3 and the year in table 2 is 2007 and the count is 1 so the counts can be added together and im just left with one 2007 value. So the final out put would be 2007 and 5? $sql1 = "SELECT year, count(*) FROM table1 GROUP BY year"; $query1= mysql_query($sql1, $link_id) or die(mysql_error()); $sql2 = "SELECT year, count(*) FROM table2 GROUP BY year"; $query2= mysql_query($sql2, $link_id) or die(mysql_error()); //don't know what to do here Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.