Re: How can I do this?? :((

"Sandeep Hundal" <sandeep_wde@yahoo.com> wrote: > Now what I want to do is have another query which asks the second > table the number of comments per each section id, for that section, > (and I think QUERY2 does this fine). But I need the answers to > integrate with the information pulled from first query. How can I > intergrate the results from 2 queries into one basically! > $query1 = " SELECT entry FROM diary WHERE month='$month' ORDER BY id > desc"; > $result1 = mysql_query($query1); > > $query2 = "SELECT count(*) AS replies FROM sexsurvey_boys WHERE > section='diary' GROUP BY sectionid ORDER BY sectionid desc"; > $result2 = mysql_query($query2); There's no common fields b/w the two queries so it's not clear how you want to merge the two queries. If you wanted all results from one table and matching results from a second table based on a common field in both tables I'd suggest a LEFT JOIN (plenty of documentation on mysql.com and rest of internet). Looks like this probably won't help in your case so you might want to look at temporary tables, which will allow you to save the results from one or both queries into a table and then run a query using the temporary tables. Or you may be able to organize your PHP code to run the second query after each row of the first query is returned and integrate the results within PHP, but you could end up running a ton of queries that way. -- Steve Werby COO 24-7 Computer Services, LLC Tel: 804.817.2470 http://www.247computing.com/