Skip to main content
Participant
April 12, 2008
Question

advice for best way to do this dynamic table -please help

  • April 12, 2008
  • 1 reply
  • 250 views
Hello, I would like to create paginated recordsets without specifying the filename over and over again. For example, if I have folders of pictures with sequential filenames, is there anyway to get around manually entering them in the database? If not, what is the best way to go about doing this because I will have a great number of these "books" to create. Maybe there is a way to just auto-enumerate a 1.jpg, 2.jpg, 3.jpg, 4.jpg etc in the db and then I can just drop in the pictures since the path would be the same.

I'm using php/mysql for the db end.

Many thanks in advance!

dwnoob
This topic has been closed for replies.

1 reply

Inspiring
April 13, 2008
Why not have a record ID# and have the code programatically generate the
image name? That way you wouldn't need an image field at all, e.g.,

<img src="/path/path/path/imagename -<?php echo $rs_recordset['recordID'];
?>.jpg"....

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"dwnoob" <webforumsuser@macromedia.com> wrote in message
news:ftrh3v$2a8$1@forums.macromedia.com...
> Hello, I would like to create paginated recordsets without specifying the
> filename over and over again. For example, if I have folders of pictures
> with
> sequential filenames, is there anyway to get around manually entering them
> in
> the database? If not, what is the best way to go about doing this because
> I
> will have a great number of these "books" to create. Maybe there is a way
> to
> just auto-enumerate a 1.jpg, 2.jpg, 3.jpg, 4.jpg etc in the db and then I
> can
> just drop in the pictures since the path would be the same.
>
> I'm using php/mysql for the db end.
>
> Many thanks in advance!
>
> dwnoob
>
>