Results 1 to 1 of 1
Jun 17, 2005, 08:52 #1
- Join Date
- Jun 2005
- 0 Post(s)
- 0 Thread(s)
Updating MySQL Img/Text With PHP HELP!
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
$sqlquery = "INSERT INTO $table
$results = mysql_query($sqlquery);
print "<HTML><TITLE>Update VZones Art Database</TITLE><BODY
print "<p><font face=\"verdana\" size=\"+0\"> <center>The VZones Art Database Has Been Updated!<p></td></tr></table>
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.