Help with MYSQL and PHP

[triponcito]

Hi guys!, I need a little help here. I am a new PHP user and I have been able to connect to databases, display the exact results that I want and that kind of thing. But now I would like to look nice..... meaning that I would like to be able to put images pulled out from my database. How would I do that.

---

|*text +background |_______|______|
|1 | just text |
||____________________________________|
| | | | |________________________________________|

• text and background would be premade in fireworks.
  ** 1 = a smiley face for example

does this make any sense to you???

I would like to make something like this (visually)
http://phpbb.com/admin_demo/

Thank you in advance!

[marque]

If what you mean is seperating code from design have you tried in your while, if and foreach statements as well as your functions ending the php tag prematurly before adding the closing }

this is what i mean:

<?php
$SQL ...

while($row = mysql_fetch_array($result)) { ?>
Hello <?php $row[FirstName];  ?>, welcome to...
<img src="logo.png">
<?php } ?>

By the way, don't keep images in the database if you are intending to, it's bad! Especially for backing up. Rather chmod a directory to 777 and upload the images there.

[triponcito]

What you wrote gave me an idea!

Thank you!

[triponcito]

What you wrote gave me an idea!

Thank you!

[trooper]

Just to second what marque said

Its a very bad idea to store images in the actual database. Not only (as noted by marque) does it make backing up a problem but it also increases the size of the database dramatically.

A better option would be to store the path names to the files in the database and have the images in a particular directory.

HTH

GM