what would be the best way

[dmcglone]

Hi all,

I'm looking for the best way to display all the images in a folder for certain pages, but I don't want to have to enter every image name into the database. here's a little bit of code that I have so far, I'm not sure if its the best way to accomplish the task but it does work, it just requires every image name to be in the database.

<?php
$edges = "SELECT * FROM edges WHERE edgecatagory= '".$pg."'";
$result = mysql_query($edges);
while ($row = mysql_fetch_array($result)){
echo "<h1><span>$row[header]</span></h1><br />";
$imgname = "$row[imagenumber]";
$imgfile = "$row[edgecatagory]";
$src = "<img src = images/tops/$imgfile/$imgname width='175' height='125'>";
echo $src;
echo "$row[description]";

}
?>

[dagon]

you can just loop through the images in a folder with out the need for a db, unless there's something in the db that relates to the images, have look at glob() in the manual

[dmcglone]

dagon;10900270 wrote:

you can just loop through the images in a folder with out the need for a db, unless there's something in the db that relates to the images, have look at glob() in the manual

Hmmmm. That's food for thought.

I didn't think about this. Maybe it was because I was thinking I had to somehow link that folder to the page that would display them in the database.

What I was doing was grabbing the edgecategory and using that as a header for the page and under it I was trying to display only the images for a given category and the category had the same name as the header.

For instance if the header says "post" then I want to display all the pictures in the "post" folder only.

I'm still trying to learn. :-) Everything I try and code, the back of my mind keeps saying "is this the right way", "am I doing it correctly", "please let it work."