Additional graphics built in to PHP/MySQL page

[Dabrowski]

I recently switched a customer's site over from static HTML to PHP/MySQL. Previously, there were pages with a block of text that I had inserted some random graphics to add a little spice. Now, with the page being database-driven, it's not so simple to have the code occasionally insert a graphic every once in a while.

When you're dealing with several things in a database, and you want it to loop through the records, it's easy enough to give each record the option of having a photo associated with it. Thus, you'll see lots of pictures. But if it's a description of something, with lots of paragraphs of text, you would probably be using just one text field, so to add a picture to that would require more work.

As I write this, I remember something I thought would be a solution: Even if it's a large page with lots of text paragraphs, perhaps it could still be broken down into paragraphs with picture adding options. They wouldn't be able to, say, write a long description in a word processor and dump it in really easily into a text field--he'd have to do it paragraph by paragraph--but at least there'd be the option of having some pictures spattered here and there.

If anyone has any other ideas, I'm interested. But it seems that having a website forces a person to choose a balance between style, flexibility, and ease. Using FrontPage will give you ease and flexibility, but not necessarily style. And without putting in a lot of work for every tiny option, a user might sacrifice a little bit of flexibility to have a solid, database-driven site.