Re: multiple tables and amounts

hi! yes - it seems as if there was no way out. i'll have to render it without this php-class. i didn't thought that it's not possible to do such queries in sql - well at least i don't know how to do them?? :/ thx for your answers! -mathew # life would be easier if i knew the source code... > Von: "Robert Sossomon" <robert@gcnorris.com> > Organisation: Garland C Norris Company > Antworten an: <robert@gcnorris.com> > Datum: Thu, 29 Jan 2004 11:10:04 -0500 > An: <grillen@abendstille.at> > Betreff: RE: [PHP-DB] multiple tables and amounts > > I may be able to hack the XML code to do it, but with wanting a COUNT of > each based on the ID, it is going to be difficult to do it in 1 query > only, in my opinion at least... Is there a way to out-think the XML > generation to grab the items you need? > > > > -----Original Message----- > From: ma [mailto:grillen@abendstille.at] > Sent: Thursday, January 29, 2004 10:40 AM > To: PHP-DB > Subject: Re: [PHP-DB] multiple tables and amounts > > > hi! > > thanks a lot for your answer. i also thought of dividing the problem > into several selects, but the application i'm working with (it's > designed by a friend of mine, which lets you easily generate XML out of > an sql) only accepts one single query.. > > do you know about any problems using CREATE TEMPORARY TABLE - eg. when > there are a lot of users accessing the page? > > thx for your help again! > > -mathew > > > # die welt ist schnell geworden... > >> Von: "Hutchins, Richard" <Richard.Hutchins@Getingeusa.com> Antworten >> an: Richard.Hutchins@Getingeusa.com >> Datum: Thu, 29 Jan 2004 08:25:03 -0500 >> An: "'grillen@abendstille.at'" <grillen@abendstille.at> >> Betreff: RE: [PHP-DB] multiple tables and amounts >> >> Matt, >> >> What about this (assuming MySQL): >> >> //$photoid is whatever photo you want the details for. >> $sql_a = "SELECT id FROM comments WHERE phid = >> '".$photoid."'"; $sql_b > >> = "SELECT id FROM ratings WHERE phid = '".$photoid."'"; >> >> $result_a = mysql_query($sql_a) or >> die(mysql_error()); >> $num_comments = mysql_num_rows($result_a); >> >> $result_b = mysql_query($sql_b) or >> die(mysql_error()); >> $num_ratings = mysql_num_rows($result_b); >> >> echo "There were ".$num_comments." comments and ".$num_ratings." >> for >> that photo."; >> >> Since you're not doing anything really difficult with the queries, you > >> probably won't see much of a speed hit by doing back-to-back queries >> like this. Besides, I think doing two straight queries like this is >> going to be faster than creating and deleting temporary tables. Just a > >> guess. > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >