Warning: Cannot modify header information - headers already sent by (output started at c:\program files\easyphp1-8\www\jerrik\display_pictures.php:9) in c:\program files\easyphp1-8\www\jerrik\display_pictures.php on line 22

$Request=mysql_query ("SELECT content FROM user_Pics");
while ($Row = mysql_fetch_array($Request))
{
header("Content-type: image/jpeg");
echo $Row['content'];
}

Is it possible to have a table in a table? Sort of like a record within a record? [turing]

I also wanted to ask how to draw an image from a blob in a MySQL database? I spent a good three hours trying to draw an image stored in a blob, but nothing I've tried has worked.

A table in a table? I doubt it. You can however relate two tables together with foreign keys.

Let's taken an example:

code:

users     | posts ----------------- username  | title password  | message join_date | user_id

Notice how posts are related to users by the use of the user_id column in the posts table?

Not sure if this is exactly what you want, but this is a very common thing to see in a database.

Not in MySQL, at least not in the way you mean. There are some dbms that have mulitdimational tables witch could do somting like it but MySQL is a realtional dbms. What you probly whont is to put the primany key of the record you whont in another table in the record of the table you have, this is noramly called a foreine key. (see rdrake's post).




You can store images in databases but it is generaly a very bad idea. Esptaly for web desing applications. It is almost allways better to upload the image to the web server as a noraml file and store the url to it in the database. This saves alot of processing and loading time becues it is faster to get a string form the database and then tell the users browser to load it. It means less stress on your server and it is almost allways faster for the user.