I purchased a schedule organizer from http://www.schedule-organizer.de/en/product/demos/ - take a look at the site for how it works.
I made some alterations to the script to meet my needs
Take a look a image userview.png this displays the client side booking system - selecting and confirming appt. goes to a further details page image confirm.png. The data ‘First Name through to Telephone’ is stored in the MySQL table ‘so customer’ url=http://myweb.tiscali.co.uk/kcheung/php/table_cust.png[/url] and the data for ‘Year/class to Time of appt’ in "so_appointments"url=http://myweb.tiscali.co.uk/kcheung/php/table_app.png[/url]
The main 2 changes I am trying to make are to the admin application.
List Appointments = "Details.php shows the extra field called ‘County’ which does not ascend or descend the data see image appointment_list.png . The extra code that I added into this php script is on line 18 (more_4)
$field_list = array ("grund", "first_name", "last_name", "more_4");
This throws the error:-
Warning: Supplied argument is not a valid MySQL result resource in c:\apache\htdocs\somids\admin\list.php on line 169
Also get problems when clicking on ‘details’ to update the user appt’s. see image appointment_list.png. The ‘details’ link takes you to the appt. details see image edit_details.png, if I click ‘Edit’ button I can make changes the appt. booking. However, when trying to submit the changes returns a list of errors see image edit_send.png
Finally Schedule an appointment = reserve.php (Admin area) displays the hyperlinked word ‘details’ see image schedule_app.png. I would rather this display customers ‘county’ with a link to the appt. details.
http://www.schedule-organizer.de/en/product/demos/
