extracting info from an array in a loop

seanpaulcail

here is my query:

$query2 = "SELECT * from small_images where page_number = '5'";
$result2 = mysql_query($query2);
$SI_result = mysql_fetch_array($result2);
echo 'SI_result is' .$SI_result;

the query pulls from the table "small_images" the columns image1, image2, up to image 8

the values for the corresponding fields are etruria01_sm.jpg, etruria02

here is my loop thus far:

<?
for ($i=0; $i<$data; $i++)
{
echo "<td width='60'><a href='java_script_:;' onClick='MM_openBrWindow('e".($i+1).".htm','','width=347,height=525')'><img src='uploads/{[images+i+1]}' width='54' height='76' border=\"0\"></a></td>";}

?>

But it's not grabbing the image name

I get 'uploads/{[images+i+1]}' in my html where 'uploads/{[images+i+1]}' is in the code.

I need to grab the data from images1, images2 images3 etc

any ideas?

thanks

nemonoman

$SI_result is an array of values from the row you've selected.

echo 'SI_result is' .$SI_result; would produce (probably)

SI_result is array <<

not a list of values

Read the documentation on mysql_fetch_array:

$SI_result array contains these elements:

$SI_result['image1']
$SI_result['image2']
$SI_result['image3']
.
.
.
$SI_result['image8']

also these elements:
$SI_result[0]
$SI_result[1]
$SI_result[2]
.
.
.
$SI_result[7]

You can access the elements of the returned row by column name $SI_result['image3']

or the equivalent column position (starting with position 0)
$SI_result[2]

$SI_result['image'][2] doesen't exist, and this what your code tries to print.

Change
$SI_result['image'][$i]
to

$SI_result[$i]

and your code should work OK

seanpaulcail

My query grabs everything from the table including the fields "page_name" and page_number"

so $SI_result[$i] would not work

I need to grab the fields image1, image2, image3

So I'm thinking that I need something like $SI_result[image$i+1]

but that doesn't work in fact I get a syntax error

So what kind of php code would give me the data from image1, image2, image3 etc in a loop?

Do you understand my problem?

thanks

here's a link to the site using your recommended code:

http://www.caillouette.com/phpMyEdit2_bu/etruria2.php

you'll notice that the first two images are missing. Maybe I need to do $i+2

thanks again

seanpaulcail

I guess I can redesign my table so that page_number and page_name are after the images

that's one work around

thanks for the helping

nemonoman

<?
//somethinglike

$numberofimages=8;
for ($i=0; $i<$numberofimages; $i++)
{
echo "<td width='60'><a href='java_script_:;' onClick='MM_openBrWindow('e".($i+1).".htm','','width=347,height=525')'><img src='uploads/$SI_result[$i]' width='54' height='76' border=\"0\"></a></td>";}

seanpaulcail

I had to reorganize my database so that the images in the small_images table appeared before the page_name and pahge_number

now

uploads/$SI_result[$i]

works just fine

thanks for all the help!!

how to I mark this thread as resolved?

nemonoman

in future, you might simply explicitly define in your SELECT the columns you want:

$result=mysql_query("SELECT image1, image2, image3
FROM small_images
WHERE page_number=5");
$row=mysql_fetch_array($result);

then $row[0] would be image1, $row[1] woud be image2, etc.

with SELECT * you are stuck getting every column of the table whether you want it or not.

seanpaulcail

I wish you would have told me that before I redesigned my database,
but there is an issue, each page has a different number of images, which is grabbed from the database by the php script according to number_of_images field.

So I would have to create a loop in the select statement, according to the num_of__images field for each page.

Is this possible?

thanks again