"Unknown Column..." from simple INSERT statement

😕 I keep getting the following error "Unknown column 'cardid' in 'field list'" when I try to insert data into a table.

My SQL statement is:-

$sql = "INSERT INTO orders (cardid) values ('15')";

The column data type in MySQL is VARCHAR (20).

I've succesfully run this statement in PHPmyAdmin, and can't see why this won't work in PHP!

I've tried renaming the "cardid" column - no chage.

I've tried changing the data type of the column - no change

I've tried inserting data into other columns in the table with the same statement - that worked ok, so I know the SQL statement is ok.

Aaarrrgh!

Am I missing something simple here??!!

Please help, this is driving me nuts!!! 🙁

I suspect that either the server you are connected to or the database you have selected on that server is not what you think.

There's probably an old servver or DB out there somewhere with a table called orders but not the column named carid.

Thanks for the quick reply tomhath!

I'm running the database locally on my machine.

I've gone through the other MySQL databases and removed a db that had a table named "orders".

However, this has not made any difference when I run the SQL statement.

I've also tried declaring the database i'm using:-

$sql = "INSERT INTO jellycards.orders (cardid) values ('15')";

but this gives me the error "Access denied for user..."

Hmm....

Is there anything else I can try??!😕

I suspect you are stil connected to the wrong database. Does you php code have a mysql_select_db() call?

Doh!

You read my mind tomhath! I've just found out I was connected to the wrong database....:o :o

Everything is working like a dream now!

Thanx again for the quick response!🆒