Thanks, works.

benf — Tue, 21 Oct 2008 21:13:28 +0000

Thanks, works.

Darn it, snipped by Matt.

pr0gr4mm3r — Mon, 20 Oct 2008 18:30:11 +0000

Darn it, snipped by Matt.

pr0gr4mm3r — Mon, 20 Oct 2008 18:29:00 +0000

You need to join your tables.

So the query would be something like:

SELECT * FROM Pictures INNER JOIN Categories ON Pictures.catid = Categories.catid

Now all values from your category table will be in the $row variable in your loop.

teammatt3 — Mon, 20 Oct 2008 18:28:00 +0000

You'd want to use an inner join.

Something like:

SELECT * FROM Image INNER JOIN Category ON Image.CategoryID = Category.CategoryID

You select everything from table Image, and then JOIN it with Category where the Image's CategoryID matches one in the Category table.