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!
# die welt ist schnell geworden...
> Von: "Hutchins, Richard" <[EMAIL PROTECTED]>
> Antworten an: [EMAIL PROTECTED]
> Datum: Thu, 29 Jan 2004 08:25:03 -0500
> An: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
> Betreff: RE: [PHP-DB] multiple tables and amounts
> 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
> $num_comments = mysql_num_rows($result_a);
> $result_b = mysql_query($sql_b) or
> $num_ratings = mysql_num_rows($result_b);
> echo "There were ".$num_comments." comments and ".$num_ratings." for that
> 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