automatic updating question

[ducksarepeople2]

..

[dnast]

You could just make a database with fields of date, time, and place. Fill it up with the scheduled appearances and you're set.

In your php script do a query that selects shows that are after now() and limit the results to 1, and you'll always have the next show shown.

[tude-marie]

If you are new to databases it might not be the easiest thing to do. Basicly all you need to do, to show the content of your table (database) is to use:

<?

$data = mysql_query("SELECT row_name1, row_name2 FROM table_name");
$rs = mysql_query($data);

echo $rs['row_name1'];
echo $rs['row_name2'];

?>

I would then advise you to use something like phpmyadmin, probably preinstalled on your server by your ISP, to alter the information in the table.

If you dont want to use phpmyadmin, you will have to build a small administration module, which would require password protection aswell.