Jump to content
Larry Ullman's Book Forums

Print Database Result From Out Of While Loop

Recommended Posts

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.

Link to comment
Share on other sites

With the code you have, $imageName will only ever represent one image, specifically the last image returned by the query. So you would need to change that to an array. Then you could refer to $imageName[0] and $imageName[1] in the respective DIVs.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...