upload and unlink image problem

[hakiepoo]

i'm successfully uploading an image using the following script:

copy($FILES['image']['tmp_name'], "../news_images/".$FILES['image']['name']);

I'm then trying to insert the filename into a database:

$sql = "INSERT INTO news SET
image="$image";

the problem is that it inserts the temporary file name (eks: /tmp/phpvyGnhE)

I've tried to use unlink (unlink($_FILES['image']['tmp_name']); before inserting the image name into the database, but that does not help.

Any ideas?

[common_ground]

cany you just do this

$sql = "INSERT INTO news SET
image=""../news_images/".$_FILES['image']['name']";