Drop Database on click

[xianaier]

Hi there guys, probably a quick question for someone. I have a little gallery that suck in pictures from flickr, caches them to a mysql database and displays them via lightbox.

But whenever I change the flickr pics referenced I have to manually go into my mysql db and drop the database table so that the images will be re-cached.

Is there a way I could create a button that would do this for me?

Thanks in advance.

[Robin]

Before going to drop the table, include javaScript and make sure you do not place the form somewhere public.

Code:
<form action="droptable.php" method="post">
<input type="submit" />
</form>

PHP Code:
<?php
//droptable.php

//connect to your database here

$sql = 'drop table if exists `tablename`;';
mysql_query($sql);
?>