I can't seem to insert some data. When I write the query
INSERT INTO table (col1, col2) values ('val1', 'val2');
it does not work
When I write
INSERT INTO table ('col1', 'col2') values ('val1', 'val2');
it does not work.
However, if I copy an insert statement from phpmyadmin it looks like the second query, except I notice the quotes on col1 and col2 seem different. If I copy those quotes around the column names, then it works fine. Any ideas why and how I can get the ' that I type to work so I don't have to copy it? Thanks,