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.

Matthew

This should do it. Obviously don't put the form somewhere public, and you may want to include some javascript to prompt you before droping the table. Here is a minimal example of how to do this:

<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);
?>

Thanks allot NullPointer that worked a treat!