Database Pull into an array

coolfield

One thing I have never quite understood is arrays which is lame because they are the basic thing everyone learns. ANways. An example of what I want to do is here

http://www.clubretro.net/example.php

the current code is simple but it is static

$intro = array("enter01.jpg", "enter02.jpg", "enter03.jpg", "enter04.jpg", "enter05.jpg", "enter06.jpg", "enter07.jpg", "enter08.jpg", "enter09.jpg", "enter10.jpg");
$num = rand(0,9);

echo "<img src=\"images/enter/$intro[$num]\" border=\"0\" >";

now what I want to do is pull the image files from a database put them into that array so upon reload a random image will appear.

the database pull will be.

$sql="SELECT * FROM $tbl_name WHERE featured ='yes'";

the column name with the images is .... 'image'

SO what I need is:
(1) the array to be dynamic with the values for the photos changing depending on what photos are marked featured.
(2) and the number of images cycling through $num = rad(0,9) to change according to how many rows are pulled from the database.

I hope that makes sense... Any help you could provide would be great!

toastyghosty

I'm new to these forums but thought I'd try to give you a hand. I'm assuming the column name in your database where you are storing your image file name is "imagefile"

based on your:

$sql="SELECT * FROM $tbl_name WHERE featured ='yes'";

you can add the following:

$result =  mysql_query($sql);
// this loads all your image file names into an array
while( $record=mysql_fetch_assoc($result) ) {
     $images[] = $record['imagefile'];
}

// this gives you the key to a random item in your array
$key = array_rand($images);

echo '<img src="images/enter/' . $images[$key] . '" border="0" />";

Hope that helps.

coolfield

this is what I did but its still not working... sorry I wish I learned faster

<?	
include('ref/dbconnect.php');
$tbl_name="shows"; // Table name

$sql="SELECT image,featured FROM $tbl_name WHERE featured ='no'";
$result =  mysql_query($sql);
// this loads all your image file names into an array
while( $record=mysql_fetch_assoc($result) ) {
     $images[] = $record['image'];
}

// this gives you the key to a random item in your array
$key = array_rand($images);

?>
<img src="images/flyers/<? echo $images[$key]; ?>" border="0" />

devinemke

are you simply trying to pull random rows from your db table? if so...

SELECT image FROM tbl_name WHERE featured = 'yes' ORDER BY RAND()

coolfield

hahah, thank you so much. I feel like the biggest idiot, I can't believe it was that simple. Here are you tax payers dollars at work. http://www.clubretro.net/home.php

bradgrafelman

Don't forget to mark this thread resolved.