t;, "'PHP-DB'" <[EMAIL PROTECTED]>
> Betreff: RE: [PHP-DB] multiple tables and amounts
>
> // This is just 1 query, I have not tested it, but it may work.
>
> $get_Quote = "select ph.id, ph.img, cm.id, cm.phid, cm.txt, rt.id,
> rt.phid, rt.text from p
d";
//runs the query
$get_Quote_res = mysql_query($get_Quote) or die(mysql_error());
-Original Message-
From: ma [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 10:21 PM
To: PHP-DB
Subject: [PHP-DB] multiple tables and amounts
hi!
i have a weired problem:
there are
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
> An: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
> 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 comme
hi!
i have a weired problem:
there are 3 tables:
photos (id, img)
comments (id, phid, text)
ratings (id, phid, text)
now i tried to create a query returning the amount of ratings and the amount
of comments for all images in the photo-table.
i tried it with multiple joins, but without success...
