Problem with PHP calendar not updating date

PHP calendar

[galahad2]

Hi, have a strange issue with a custom PHP calendar not updating the date of an event, although other fields are updated without any problems. because of this, users cannot change the day / date the event appears on in the calendar after they've posted the event. Any ideas?

The code in my event_edit.php is as follows:

<?php

$event=mysql_fetch_assoc(mysql_query("SELECT id,project,site,name,description,DATE_FORMAT(date,'%d/%m/%Y') AS date,days FROM events WHERE id=".$_REQUEST['e']));

$sites=mysql_query("SELECT id,CONCAT(name,' (',number,')') AS name FROM sites WHERE project=".$event['project']." ORDER BY name");

?> <div id="Content-Header">Edit Event - <?php echo $event['name']; ?></div>
<div id="Content-Body">

<link rel="stylesheet" href="/inc/css/light.datepicker.css" type="text/css" media="screen">
<script src="/inc/js/jquery-latest.js"></script>
<script src="/inc/js/jquery.datePicker.js"></script>
<script>
$(document).ready(function(){ $('#idDate').datepicker(); });
</script>

<form action="./" method="post" onsubmit="return chkFormSite();">
<table>
<tr><th><label for="idName">Event Title</label></th></tr><tr><td><input id="idName" name="name" type="text" value="<?php echo $event['name']; ?>" /></td></tr>
<tr><th><label for="idDate">Event Date</label></th></tr><tr><td><input id="idDate" name="date" type="text" value="<?php echo $event['date']; ?>" /></td></tr>
<tr><th><label for="idDays">Event Duration (days)</label></th></tr><tr><td><input id="idDays" name="days" type="text" value="<?php echo $event['days']; ?>" /></td></tr>
<tr><th><label for="idClient">Site Name</label></th></tr><tr><td><select id="idSite" name="site"><option value="0"></option><?php while($site=mysql_fetch_array($sites)) { echo "<option value=\"{$site['id']}\""; if(isset($event['site']) AND $event['site']==$site['id']) echo " selected=\"selected\""; echo ">{$site['name']}</option>"; } ?></select></td></tr>
<tr><th style="font-weight:normal;"><label for="idDesc">Description</label></th></tr><tr><td><textarea id="idDesc" name="desc" cols="5" rows="4"><?php echo $event['description']; ?></textarea></td></tr>
</table>
<input type="submit" name="update" value="Update Event" /> or <a href="../">Cancel</a> or <a href="../delete/" onclick="if(!confirm('Are you sure want to delete this event? There is no undo.')) return false;">Delete</a>

</form>

</div>

[mattclayb]

Where is "Update Event" called in your script?

You have the 'select' statements for extracting the data, but there are no update statements for updating the database within the script you have posted?