placing an image between text

[littleelmo]

hi,
I've got text data and image data stored in a mysql database. (for articles) Some articles can have up to three images associated with them. What I want to do is to be able to place one of the three images to align around the text.

I can place one image before the text data, or I can place two images (one before the output of the text data and one after the output of the text data) But is there a way to manipulate the text data and place an image in the middle of the text data?

Is this possible? Any help would be appreciated.

[brandonschnell]

i'd seperate the text data and image locations into two tables. then in the text reference the images like so: <1> or something.

pull the images (don't store the binary data, just the locations to the images) using a id key that ties the images to the text article and number the images. replace the number index in the text <1> with an image src (a preg and a backreference) and send the text to the browser. this way you could have:

My Text Article <1> <-- insert image #1 for the text
This is a test of mixing images and text. See <2> how successful it is? Ah, better luck next time.

<3> <-- select images.id from images where images.article_id = articles.id;