Random Image/Info Display Help

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

Kudose

//assuming the image name is
//stored in the column `image`
//and the name is stored in `name`

$query = "SELECT * FROM table ORDER BY RAND() LIMIT 0,1";
$row = mysql_fetch_array($query);

echo 'Name: '.$row['name'];
echo 'Image: <img src="imgs/'.$row['image'].'">';

webdiva

echo 'Image: <img src="imgs/'.$row['image'].'">';

I can't get it to show the image.

Here's the link:

http://www.lauras-webdesigns.net/adoption/childinfo.php

I'm getting it to come up random, but just not the image.

Thanks!

Kudose

What do the database columns look like? What directory are the images stored in?
Can you post up your code?

webdiva

<?
$username="myusername";
$password="passwordhere";
$database="webdiva_features";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM child";
$result=mysql_query($query);

?>

<?PHP

$NUM = mysql_query("SELECT COUNT * FROM 'child'");
$RESULT = mysql_query("SELECT * FROM `child` ORDER BY RAND($NUM) LIMIT 1");
$ROW = mysql_fetch_array($RESULT);


echo "Name: {$ROW['name']}<br>";
echo "Age: {$ROW['age']}<br>";
echo "Location: {$ROW['location']}<br>";

?>

My columns are:

record_num
image
name
age
location

webdiva

Sorry I forgot to add, the images are in the directory

/adoption/images

however, in my databse I have 'image' and the field has the URL to the image.

I had it working before when it wasn't doing it randomly, It's something with the $ROW thats messing it up

webdiva

Hi, Just wanted to let you know I figured out how to do it using this code:

echo "<img src={$ROW['image']}><br>";

I have the site up and working now:
http://www.lauras-webdesigns.net/adoption/Adoption Agency- LAB #6

Thanks again for your help!