June 19th, 2000, 11:30 PM
the command for adding a column to the mysql table is:
alter table <table_name> add column picture varchar(20);
it's easier if all of your images are stored in one directory, that way you can just save the name, instead of all the path info. if you do have to store path info, you might want to make varchar larger than 20.
then, to get the data back out...
$query = mysql_db_query($database,"select picture from table_name where name='$name');
$result = mysql_fetch_array($query);
then, where ever you want to show the picture, use:
<img src="images/<?php echo $result["picture"]; ?>" border=0>
Hopefully that get's you going, email me if you have any other questions.