Deleting

[Ahren]

When I use this code:

$del_query = "DELETE db_username,filename,filesize,stat FROM uploads WHERE filename = '$delete'";
$del_query = mysql_query($del_query);

It doesn't delete the file information from the database, I know it's connecting, because I am using other queries on the page. It doesn't give me any errors, it just doesn't work.

Help?

[travelbuff]

Your syntax looks right to me.

Try adding an echo $delete ; statement before building the query and make sure that $delete has the value you expect it to.

try adding 'or die(mysql_error()) ;' to the end of your statement to see if their are any errors being generated.

You can also try running your statement as a SELECT statement and the return the row to see if that is what you expect it to be.

HTH,

[mcrbids]

$del_query = "DELETE db_username,filename,filesize,stat FROM uploads WHERE filename = '$delete'";

OOPs! you can't DELETE a field, you can only delete rows!!!

Try this, instead...

$del_query="Update uploads set db_username='', filename='', filesize=0, stat=null FROM uploads WHERE filename='$delete'";

Or, perhaps you meant something more like this?

$del_query="delete from uploads where filename='$delete'";

One of these two.

Hope this helps!

[travelbuff]

Right on mc! :o Goes to show I should not try and answer things late at night :p