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!
# life would be easier if i knew the source code...
> Von: "Robert Sossomon" <[EMAIL PROTECTED]>
> Organisation: Garland C Norris Company
> Antworten an: <[EMAIL PROTECTED]>
> Datum: Thu, 29 Jan 2004 11:10:04 -0500
> An: <[EMAIL PROTECTED]>
> 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:[EMAIL PROTECTED]
> Sent: Thursday, January 29, 2004 10:40 AM
> To: PHP-DB
> Subject: Re: [PHP-DB] multiple tables and amounts
> 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 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
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php