[Deansatch]

I have wrote this code for when a form is submitted. As it stands you have to enter the date as yyyy-mm-dd. I have it so that it is output on the web page as a different format but is there a way I can let users input the date as dd-mm-yyyy or use any format?

PHP Code:

if ($action == "updategigs") {

$heading_gigs = $_POST['heading_gigs'];

$gigs_title = $_POST['gigs_title'];

$venue = $_POST['venue'];

$date = $_POST['date'];

$gigsextra = $_POST['gigsextra'];





$connection = mysql_connect($host,$usr,$pwd);

mysql_select_db("$db", $connection);

mysql_query("INSERT into table_gigs (date, venue) VALUES ('$date','$venue')");

mysql_query("UPDATE table_home SET gigs_title = '$gigs_title',gigsextra = '$gigsextra'

WHERE id = '0'");

echo "<script>document.location.replace('gigs.php')</script>"; 

[Nico]

You could use drop down menus, and rebuild the date after the submission for your needs. This way you can be sure the client doesn't mess it up.

[Deansatch]

I thought about doing that, but I don't know how to get the three results from the form and make them in to one to call the combined result "$date"

[Nico]

Like this for example.

PHP Code:

$date = $_POST['year'] .'-'. $_POST['month'] .'-'. $_POST['day']; 

But I would store the date as timestamp. This way you can search the database easier, and output the date in every format later without big changes. Do this if you want to:

PHP Code:

$date = strtotime($_POST['year'] .'-'. $_POST['month'] .'-'. $_POST['day']); 

[Deansatch]

excellent once again! thanks