Just a piece of advice.
Im not sure how firebird deals with this but i am using mySQL with phpMyAdmin and if anyone is having trouble getting the itemID in the order table to references it in the menuItem table it is because ORDER is a reserved word. You are going to have to change the name of the table to something else.
Subscribe to:
Post Comments (Atom)
3 comments:
There is the same problem in Firebird. I used foodOrder.
I had the same issue in Firebird. You can also use quotations to force it.
Sorry for the oversight. Either of these are fine solutions.
Post a Comment