upload new image and update path in mysql

[zerobde]

Okay, I've been trying to figure this out for a while on my own and as well as reading posts. I have modified a news script to include images and it works fine. the problem i'm running into, i don't even know if it's possible, is my edit script. i have it showing all the info including the current image.

what i want is to upload a new picture and have it replace the current picture where the id = id. one variation of my script inserts the new image path into the database and doesn't upload the new picture to the server and the other variation does the opposite. is there any way possible to do both in the same script?

Is there a simpler way to do this? Could i also just have the script read all the available images on the server and choose a new one that way? Of course after manually putting the images into the designated server folder. By the way, i'm learning php on a home computer for testing purposes (php, mysql, apache on win 2k/win xp). hmmm, that just gave me an idea.

thank you for your time.

[Nate]

<?php

//move the uploaded file
$uploaddir = '/var/www/uploads/';
$uploadfile = $uploaddir . $_FILES['userfile']['name'];
move_uploaded_file($_FILES['userfile']['tmp_name'], $uploadfile);

//connect to your database

//update your news record with the new image path
mysql_query("UPDATE news SET image_path=$uploadfile WHERE news_id=1");

?>

[zerobde]

Thanks for the reply Nate, but my script works the same as yours. I substituted my '$_GET[id]' with the id number (51 for example) and it works. So basically, my script isn't grabbing the id number when executed. That narrows things down at least. I just have to figure out what's wrong.