I got a new host for a new site i made and i have a bit of issue with the mysql system on the new host.
first off they have register_globals set to off which i have made adjustment to but when i try to enter a query like this:
insert into ebb_category (Name, Order) values ('$name', '$order')
i get this error:
[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Order) values ('General', '2')' at line 1[/quote]
now that table has 3 columes but that colume is the id which i set to auto incredment, so any idea on how to make this work.