display data from mysql array one row at a time

[wadro21]

Hello everyone,

i am trying to pull from a myql database all records from a table with multiple rows. i need to be able to call the data from each row one by one i would asume from an array. the trouble is i can select the data from mysql but dont know how to print the data in php one row at a time. here is my code:

$imgquery= "SELECT * FROM `forsale` where `row_id` != 1";
$imginfo=mysql_query($imgquery);
 
while($get_img_info =mysql_fetch_array($imginfo, MYSQL_ASSOC)){
 
      $image=$get_img_info['pic_name'];
 
}
        print $image;

there are 15 images in this array but i dont know how to call them.

[Markus]

$imgquery= "SELECT * FROM `forsale` where `row_id` != 1";
$imginfo=mysql_query($imgquery);
 
while($get_img_info =mysql_fetch_array($imginfo)){
 
     echo $get_img_info['pic_name']."<br />";
 
}
 
 

This will, or should, run through the images and print them out until the array returns false.

Sorry if i misunderstodd your question!

[wadro21]

close, but what i need to do from here is to assign all of the printed values into a new array that i can call one by one later on by number like array['1'], array['2'] or keep them in this array but to call them one by one.

[Atli]

Hi.

Using Markus' code you can do whatever you want with the value. You could simply change the echo statement so it adds it to an array instead.

[Markus]

I'm not sure how i would do that actually, i look forward to seeing an answer :)

[wadro21]

so what is the code that would put it into an array? i know what i need it to do, i'm just not sure how to do it.

[Atli]

Consider this alteration of Marcus' code.

# As you are only using the 'pic_name' field in you table I've
# replaced the * with the field name to increase efficiency.
$imgquery= "SELECT `pic_name` FROM `forsale` where `row_id` != 1";
$imginfo=mysql_query($imgquery);
 
# This creates an empty array.
$myArr = array();
 
# Note that I use the mysql_fetch_assoc() function here instead 
# of the mysql_fetch_array() function to increase efficiency.
while($get_img_info =mysql_fetch_assoc($imginfo))
{
    # This adds the 'pic_name' field of the current row to the
    # next available index in the array, starting with 0.
    $myArr[] = $get_img_info['pic_name'];
}
 
# Now you can call fields using indexes like so
$row0 = $myArr[0]
$row1 = $myArr[1];
# etc...
 
# Or you can loop through them all using a foreach loop
foreach($myArr as $_k => $_v) 
{
  echo "Row {$_k}: {$_v} <br />";
}
 

Is this what you had in mind?