updating a database by loading files

seanpaulcail

I'm using phpMyEdit as a backend administration tool

I have a table with the folowing fields:
page_number
page_name
Image1
Image2
Image3
Image4
Image5
Image6
Image7
Image8

I can overwrite an image with the upload tool but I can't add a new image to my table, though my script says it has been added. I also check my uploads folder and the new image is in there, it's just not listed in the table.

here's the code I'm using to insert an image link into the table

$query = "UPDATE $table_name SET $radiobutton='$userfile_name' WHERE page_name='$insertartist'";

  mysql_query($query) or die("Could not complete update of database");

echo "<p><b>Your image was added to the Eli Jewels small Images table. </b></p>";

radiobutton is Image1, Image2 Image 3, up to Image 8.

insert artist is the row_name

Image8 is a blank field. I'm trying to add an image to the Image8 field but it doesn't work. I can successfully overwrite other images with the upload feature.

Why can't I add a new image to a blank field?

Any help is appreciated

dopey

Hi,

Can't really help you, but you might want to echo out the the query you are executing to see what exactly is being run.

seanpaulcail

But I figured it out

I needed to use page_number instead of page_name

$query = "UPDATE $table_name SET $radiobutton='$userfile_name' WHERE page_name='$insertartist'";

Thanks anyway