INSERT into MySQL leaves field empty?

[Anon]

Hi experts,

I am using MySQL and PHP just to get a feel of how to insert data into a database. However, once I try to update the database, it leaves all the fields blank. It adds rows, and even auto increments my index, but it does not insert the data. Is this a PHP problem? An SQL problem? Or an Apache problem? I'm very confused. Can you please help me?

-Drew

[okyejr]

why not show us your code?

[flipis]

Sure, give us the code and we'll see (although this looks to me like a problem with POST variables)

[djurnoce]

I had a similar problem when I was starting out. Make sure you put quotes around anything that isnt a straight number, including text, dates, etc. Also, I find it very helpful to echo() all the variable snad the entire query before they are executed, so I can see exactly what is being passed into the SQL engine.

[flipis]

Yes, like this:

INSERT INTO table (name,surname,address) VALUES ('".$name."','".$surname."','".$address."')

And echoing variables is definitely the best way to find out the bugs.

Cheers !!!

fLIPIS