Deleting info from column in mysql

kpowning

I have a table that includes a column "vimage" and a column "username".

On form submit, I want to delete any information that is in "vimage" for the user whos username = username in the table.

How can I make this in an If statement?

I know this is probably something really easy, but I'm a newbie trying to understand these basics... Thanks in advance..

LordShryku

Well, if you just point your form to a new page, there's no need for a conditional...

kpowning

I'm not following u, this is for quering a the mysql database.

LordShryku

Well than what kind of "if" statement are you looking for. I don't think I'm following you. The form gets submitted, set the field to null.

Weedpacket

The SQL statement you're looking for is UPDATE

kpowning

weedpacket thanks for the input, but here is my actual problem. Let me know what you think I should do please.

I have an upload form that inserts the members vehicle image that they upload into my database table column name "vimage". Also it saves their image to "/members/images/" How can I make my script delete their vehicle image if one already exists from the database and "/folder" and then allow them to upload a new image to both.

Thus, not saving file after file to my "/folder"?

Anyhelp would be appreciated..

Shrike

Can't you just overwrite both the file and the SQL cell? If not then

$result = mysql_query("SELECT vimage FROM table WHERE username = '$username'");
$vimage = mysql_fetch_assoc($result);
unlink($vimage['vimage']);
$result = mysql_query("UPDATE table SET vimage = null WHERE username = '$username'");
...
blah blah
...
upload code in here
....

kpowning

How can I overwrite them both? The file that is currently being used and the link to it in the table?

Thanks for the help..

kpowning

NEVER MIND!! I'm a newbie.. This worked!

Thanks for the support..🙂