Re: unlink problem... please help...

At 16:03 26.02.2003, Jøran Sørbø spoke out and said: --------------------[snip]-------------------- > if (isset($delimage)) > { > >$result=unlink('$dir_to_upload/$Photo'); > > $result=mysql_query(" > update product set > Photo='nothing', > miniPhoto='nothing', > picture='0' > where ID=$id > ") or die (mysql_error(). " : ".mysql_errno()); > > if ( ($result) != 1) > print "Sorry,can't delete the image "; > else > { > print "Image was deleted sucsessfully.<br>If you want to upload a >new image do it now,overwise close the window"; > } > > } > >but when i execute this, i get the following error... > >Warning: unlink() failed (No such file or directory) in one_product.php on >line 178 >You have an error in your SQL syntax near '= ' at line 6 : 1064 --------------------[snip]-------------------- 1) You do not define $dir_to_upload, nor $Photo (at least in your example) - this would lead to $result=unlink('/'); hence error 1. 2) You don't define the variable $id (at least in your example), so the SQL statement would read "update product set " . "Photo='nothing', miniPhoto='nothing', picture='0' " . "where ID=" hence error 2 (after "ID="). If these values are available on a global level, you must declare them global within your function. -- >O Ernest E. Vogelsinger (\) ICQ #13394035 ^ http://www.vogelsinger.at/