Hello,

I have been googling' all morning to try and find the answer to this.

I have no problems updating my database with 2 PHP scripts, to update the VARCHAR fields.

My data base also as a MEDIUMBLOB Image field, and I want users to be able to upload an image on the same form.

Does anyone know where I can find a script that incorporates both, because I can only find one or the other.

This is the file that I submit the form to:
<?
$DBhost = "localhost";
$DBuser = "dbhost";
$DBpass = "password";
$DBName = "bdname";
$table = "table";
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");

@mysql_select_db("$DBName") or die("Unable to select
database $DBName");

$sqlquery = "INSERT INTO $table
VALUES('$img','$imgtype','$imgurl','$description','$zone','$color','$chores','$activate','$size','$restrictions','$class','$comments')";

$results = mysql_query($sqlquery);

mysql_close();

print "<HTML><TITLE>Update VZones Art Database</TITLE><BODY
BGCOLOR=\"#FFFFFF\"><center><table border=\"0\"
width=\"500\"><tr><td>";
print "<p><font face=\"verdana\" size=\"+0\"> <center>The VZones Art Database Has Been Updated!<p></td></tr></table>
</center></BODY></HTML>";
?>


I can update everything except the first IMG field, thats the blob, can someone please help me edit this script to allow me to upload a picture using a form. I'm not great with MySQL or PHP, not a programmer, but with help I should be able to figure it out.

Thanks,
Greg