Random DB Error

[eluser]Jay Logan[/eluser]
I have made your changes. Though I don't think it works properly. I tried to add another school and got this error:

Code:

A Database Error Occurred

Error Number: 1062

Duplicate entry '0' for key 1

INSERT INTO `schools` (`abbr`, `name`, `city`, `state`, `type`, `host_id`, `id`) VALUES ('WDSK', 'WOODSTOCK', 'WOODSTOCK', 'GA', 'H', 0, 'd6f406048b2ff09224875456449a')

I hit the refresh button, and got this error:

Code:

A Database Error Occurred

Error Number: 1062

Duplicate entry '60' for key 1

INSERT INTO `schools` (`abbr`, `name`, `city`, `state`, `type`, `host_id`, `id`) VALUES ('WDSK', 'WOODSTOCK', 'WOODSTOCK', 'GA', 'H', 0, 'd6f406048b2ff09224875456449a')

So it appears to be grabbing random ID numbers without checking to see if that ID already exists in the DB.