dcsimg
www.webdeveloper.com
Results 1 to 6 of 6

Thread: 4x4 web gallery using databases

  1. #1
    Join Date
    Jun 2010
    Posts
    21

    4x4 web gallery using databases

    Hi

    Im using Dreamweaver CS4 and am still fairly new to web developement (recently acquired my adobe dw cs3 ace)

    I am trying to create a 4x4 web page gallery using ASP Javascript and MS Access. I insert a master detail page into a 4 colum table that repeats 4 times. I then extended the table and duplicate the code to another 3 colums. The problem is that when I duplicate the code it also duplicates the images.

    What I am ideally trying to create is a different image in each cell which is retrieved from the database.

    The only programming experience that I have is Java from highschool. I have looked at the code and am a bit confused by it.

    This is probably a common question, I have googled a bit but havnt really found any help.

    Thanks in advance,
    Nick

  2. #2
    Join Date
    Feb 2007
    Posts
    46
    this is a simple fix.

    You need to move next after each of the td's, you will probably also need to check for eod and enter nothing for td's with no pictures available

  3. #3
    Join Date
    Jun 2010
    Posts
    21
    Thanks for the reply
    I remember trying to do something like that but was unsure of how to code it .
    I'll try again today and see if I come right

  4. #4
    Join Date
    Jun 2010
    Posts
    21
    Thanks
    I eventually got it to work now, I took the while out which was causing most of my problems I think, and then just added all the code manually which is a little messy, but is doing the job.

    There is one funny thing that I have noticed, and Im not sure if its got to do with my database or not.

    My photos are named in numerical order 1-62. When the page is loaded images
    1;10;11;12;
    13;14;15;16;
    17;18;19;2;
    21;22;23;24;
    are loaded.

    I think this is an error with the information being passed between access and dw. Is there a fix for this, or am I doing something wrong?

  5. #5
    Join Date
    Jan 2008
    Location
    Florida
    Posts
    1,227
    You need to add an "order by" clause to your SQL query

  6. #6
    Join Date
    Jun 2010
    Posts
    21

    Smile

    Thanks for the reply,

    Just checked to see if I had one after you replied, and realised that I need to remove it because
    image/11.jpg
    is alphabetically before
    image/2.jpg

    Thank you all so much, I'm really happy with these forums, although my questions are simple I'm not recieving any hate commenting are abusive bant.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles