[webdiva]

Hi,

For class I need to create an adoption agency website. On the main page I need it to include a "Featured Child", randomly, so when you refresh a new one displays. I need all the information in a database. I have the information in the database, now I just need the information on how to display a random row of information from the table. I also am not too sure how to display the url link to the picture so that the Image shows.

Any help would be greatly appreciated, Thanks

Laura

[jd_957]

could you use the following? it looks like it would work.

http://jscode.com/js_random_image.shtml

[webdiva]

Nope, I wish I could, it would be so much easier. We have to use PHP/mqSQL and no javascript

Right now I have the following done:

http://lauras-webdesigns.net/adoption

It shows a featured child, but the PHP code for it displays all rows in the table. The actual URL to the featured child is: http://lauras-webdesigns.net/adoption/childinfo.php

I need to have it so that everytime the page is visited it shows a random child. Or even like I have the featured articles, a different article a day, I got that script from someone else and don't know how to implement the children into it.

[Squashman]

I dont know what script you are using currenlty so I really cant help you with implementing it but here are a few other scripts you could try. I couldn't find any that use MySql. Seems like most of them just pull from a directory.

This looks promising but doesn't use MySql. But it does allow you to display text underneath the picture.
http://www.hotscripts.com/Detailed/36791.html

This one allows you to link a url to each image.
http://www.hotscripts.com/Detailed/35931.html

Edit: Found one with Php/MySql
http://www.designplace.org/scripts.php?page=1&c_id=13

[jd_957]

maybe this is it.http://www.weberdev.com/get_example-400.html

i found that here. http://www.weberdev.com/

having never built a web site. i can only search and read. so i am not one to get into the technical stuff with.

[nonane]

Originally Posted by webdiva

Hi,

For class I need to create an adoption agency website. On the main page I need it to include a "Featured Child", randomly, so when you refresh a new one displays. I need all the information in a database. I have the information in the database, now I just need the information on how to display a random row of information from the table. I also am not too sure how to display the url link to the picture so that the Image shows.

Any help would be greatly appreciated, Thanks

Laura

Looks like you may need a PHP developer as well.

[brendandonhu]

Have MySQL count the number of rows in your table. Pick a random number of rows between 0 and the number of rows, and display the image with that ID number.

[webdiva]

Hi, I got it working, thanks for all your help

http://lauras-webdesigns.net/adoption

[tsunam]

also of note you can do it with strictly CSS as well (gotta love css...and even IE will like that bit of css...unlike most of the stuff it does)