Edit appointment screen not showing all fields

Asked by David
6 years ago.

Hi,

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]
6 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 1 month old and has been closed. Please create a new question if you have anything to add.