UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support How to delete an attachment on a posting?

[quote]Originally posted by Dave_L:
The only way to do this is to manually delete the file from the server, and clear the relevant column in the database.

I think this would be the correct query, where xxxxxx is the post number:

<pre>UPDATE w3t_Posts
SET B_File = NULL
WHERE B_Number = xxxxxx[/code]

Warning: Stupid newby question! <img border="0" title="" alt="[Wink]" src="images/icons/wink.gif" />

In PHP Myadmin would you just enter those lines one at a time, pressing return after each one to execute them?

Da LAN Tech