Print database result from out of while loop

thara

hello... everyone..

I have some small problem. It is when Im fetch data from my database and print those in different location.
I have a database to store images and it contain many type of images. Eg. gallery image, comments image, ad image and so on. So now I need to get only images which type is 'ad'.

Note: A single user can store only 2 images as ad images. That mean there are two ad images to a particular user.

It ok for me. I did it like this.

$q = "SELECT image_name FROM images WHERE image_type = 'ad' AND user = $id";
$r = mysqli_query( $dbc, $q );

while ( $row = mysqli_fetch_array( $r, MYSQLI_ASSOC)) {
  $imageName = $row['image_name'];

  $imageName; // two images contain in this variable.

}

My problem is, can anybody say, is there a way to print those 2 images in different location (in different two DIV ) and out of while loop.

Eg: <div class="add1"> image1 </div>
<div class="add2"> image2 </div>

any comments are highly appreciated.
thank you.

Derokorian

You could call the query, and the loop where you actually want to output the images. Additionally you could store the images in an array within the loop, then just access that array where you need it:

while( $row = mysqli_fetch_array($result) )
{
    $images[] = $row['image_name'];
    // Whatever else you do with the query results
}

// Later on....
foreach( $images as $k => $image )
{
    echo '<div class="add'. ($k+1) .'">'. $image .'</div>';
}

Hope that helps.

thara

thanks for response...

Your solution is okay. But assume those two div located in different places. Eg. one div in sidebar section and 2nd one in content area of the page. Then how can do it..?

Thanks in advance.

Weedpacket

First of all you'll need some sort of ORDER BY condition to get the results in a reliable order (unless it doesn't matter which one ends up where).

Then you'd put [font=monospace]$images[0][/font] in one place and [font=monospace]$images[1][/font] in the other.