Forum Moderators: coopster

Message Too Old, No Replies

Listing mysql query

         

gonny

9:04 pm on Dec 20, 2008 (gmt 0)

10+ Year Member



Hi all!
How I can list categories with entries from two query.
example:

$query = $DB->query("SELECT id, title FROM gallery_cat ORDER BY `id` DESC");
$cat = $DB->fetch_row($query);
$idcat = $cat['id'];

$queryn = $DB->query( "SELECT id, title, image, id_cat FROM gallery WHERE id_cat='$idcat' ORDER BY id DESC");

I want to list like this:

CATEGORY 1
image1 - image2 - image3 - image4 - image5
CATEGORY 2
image1 - image2 - image3 - image4 - image5
CATEGORY 3
image1 - image2 - image3 - image4 - image5
ect... by 5 result foreach category.

Any help?

gonny

1:19 pm on Dec 21, 2008 (gmt 0)

10+ Year Member



....waiting

coopster

1:51 pm on Dec 21, 2008 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



Have you considered using a JOIN?