Page 1 of 1

Newbie requires help - Think it will be simple

Posted: Wed Jun 14, 2006 5:07 am
by geordie
I am redesigning a site which includes some profiles of dancers, I would liek to be able to show an image from the database on profiles.php and have the image link to actual_profile.php

I have created the database and also the forms to Add, Edit and delete the profiles from the database. Where I am struggling is to create the profiles page and have it link to the actual profiles page.

The image is alread in the database so the profiles page would need to pull the images from the table and display them in a table such as

Image 1 Image2 Image3 Image4 Image5

Image 6 Image7 Image 8 Image9 Image10

And so on.

Each of these images would then link to their actual profile.

Have I explained this well enough? Is what I would like to do possible? Could anyone explain how I do it in Dreamweaver?

Many Thanks

Paul

image display solution

Posted: Wed Jun 14, 2006 5:48 am
by lettie
One question before I try to answer this for you.

Have you got a basic understanding of how to code with php or are you trying to use dreamweaver to do this?

Posted: Wed Jun 14, 2006 6:06 am
by geordie
I will be using dreamweaver as I have very little understanding of how to code PHP by Hand.

I have started by reading a book called "Foundation PHP for dreamweaver 8" which has taught me enough to create the news articles page that I wanted.

I have taken this problem a little further as I have 1 picture showing up on the Profiles page and have succesfully got it to point to the correct profile using profile_id.

I am only struggling now really to get image 2 in cell 2 and image 3 in cell 3 etc etc. I presume this will be done with a repeat region behaviour but am unsure as to how to move forward.

Many Thanks

Paul

Posted: Wed Jun 14, 2006 6:34 am
by lettie
ok well if you are unfamiliar with php code its unlikely anything I post will make sense. However it can be done with a while loop drawing the info from the database with an mysql query then populating each table row with the information while there are avaiable row in the database table.

If you are looking for a good book on basic php and mysql programming I would totally recommend PHP and MySQL for dynamic web sites by Larry Ullman. I self tought from this myself and still use it for reference now. Its very well written and easy to follow.

Posted: Wed Jun 14, 2006 5:00 pm
by feyd
I'd suggest reading the first link in Useful Posts (look inside the Forum Tour link in my signature.)