MySQL/PHP error

Status
Not open for further replies.

ziycon

New Member
I keep getting this error when i click the submit button on my form and cant figure out what the problem is, i've checked all the code and im stumped!
Unknown column 'MARY' in 'field list'
 

Cormac

New Member
you will need to tell us the php query and provide us with the db table to determine the error

it looks like you're trying to post to a variable "Mary" but maybe the field should be user or name or something and the value should be mary?
 

ziycon

New Member
Got it sorted, jus a quick question, what do you put in PHP to make the DB auto increment on a new entry being added to the DB?
 

louie

New Member
you don't ask php to do that for.
It's a setting in the database table to auto-increment the records by 1
make sure the field is set as int then check the box that says auto-increment.
 
Status
Not open for further replies.
Top