search envelope-o feed check
Home Unanswered Active Tags New Question
user comment-o

Edit appointment screen not showing all fields

Asked by David
2 years ago.


Just checking out your excellent application but when I go to accept the appointment the appointment_edit screen doesn't show all of the fields.

Answer posted by Dan Letecky [DayPilot]
2 years ago.

It looks like there is a problem with SQL on line 51 (appointment_edit.php) which works in SQLite but not in MySQL:

foreach ($db->query('SELECT * FROM [doctor] ORDER BY [doctor_name]') as $item) {

It should work fine if you change it like this:

foreach ($db->query('SELECT * FROM doctor ORDER BY doctor_name') as $item) {

This question is more than 3 months old and has been closed. Please create a new question if you have anything to add.