I had created a table and started populating it, but did not get to certain fields until later.
When I tried to do an insert it would not go. It was not reconizing 2 fields. I read and re-read the statement etc. Tried it from phpMyAdmin, command line and my php script.
Anyways, I removed one field and put it back in and it worked... But now I really wanted to figure out why.
After another few minutes of invetigation I realized that I had a trailing space in the name.
It was due to copy and pasting the names into phpMyAdmin. You would think someone would haver put a trim in there.
Well... Just thought I would pass on this experience.
Cheers, Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]