Image Gallery Problems

kamy99

Hi all:

I'm totally stuck on my new problem 🙂

Basically I want to create an image gallery. I've done it many times before, however this time it is with three tables, so that's where problems start.

I have three tables:

Pixtures (ID, Path),
Categories(ID, Name),
CategorizedPix(ID,CatID,PixID)

This was done because an image can go into many cats and a cat may contain many images.

I must have three pages:
1) Show all Cats , no problem, done!

db_connect();
$sql=mysql_query("SELECT * FROM Category ORDER BY Category ASC");
while ($special=mysql_fetch_array($sql))
{
?>
<a href=cats.php?CatID=<? echo $special[0];?>>
<? echo $special[1];?></a>
<?
}
?>

2) Show all the pictures from that category.
This is the PROBLEM AREA!!!
I wanna show all the images , and their paths. I know I have to use joins, but just can't get it to work!!

3) Show picture. No problem.

db_connect();
$sql=mysql_query("SELECT * FROM Pictures WHERE ID='$PixID'");
while ($Pix=mysql_fetch_array($sql))
{

echo $special['Path'];
}
?>

----------

Thanx in advance for your thoughts!

RGBlackmore

use

Pixtures (ID, IDcategory, Path) table instead of Pixtures (ID, Path).

You can first get the ID from the category, from Categories table (call it $catID), and then do some like:

select * from Pictures where IDcategory='$catID' order by ID ASC

good luck

kamy99

Pixtures (ID, IDcategory, Path) table instead of Pixtures (ID, Path).

That's no-go. Because, as I've mentioned before it's a many-to-many database. Any image can go into many categories, and category can have many images.

Ofcourse, please feel free to correct me!😃

I think I need to use two joins, but sa far I had no success!

Thanx

Chimera

This should be what you need :

$catID = (the category ID you want to view);
$sql=mysql_query("select Pixtures.* from Pixtures, CategorizedPix where CategorizedPix.CatID = ".$catID." AND CategorizedPix.PixID = Pixtures.PixID");
while(...etc etc.