[RESOLVED] noob question on removing mysql data

[camoconnell_com]

Hey there,

I'm nearly finished developing an image upload page for a client, and it occur to me that i hadn't really put much thought in how my client would remove uploaded images (if she so choosed to).

The images are uploaded to a directory and a url record is kept in mysql, and subsequiently written to xml and passed on to the .swf file.

i notice the other day when i removed all the images from the directory then uploaded a new image, php wrote to the xml all the pre-existing images url's of the images that weren't there, i guess this being because i hadn't notified mysql huh?

Could someone please put me onto a tutorial related to removing server side data and wiping it from its mysql table concurrently.

Thank you :rolleyes:

[camoconnell_com]

also to note, i have actually tried looking for this information but no cigar.

[Crowly]

To remove/delete a row in a table

DELETE FROM table WHERE id=1

Modify as needed.

Or to empty the entire table

TRUNCATE TABLE table_name

[camoconnell_com]

thanks Crowly, that should get me started🙂