[PHP] Unable to send variables to MySQL table

2005-11-09 Thread Stewart Priest
Hi folks... a bit of a newbie question I'm afraid... I've written this script shown below. It gets its variables from a form, and then it (supposedly!) writes these values into a MySQL table ('invoices'). The script executes with no errors, but when I check the table, the table is still empty.

Re: [PHP] Unable to send variables to MySQL table

2005-11-09 Thread Stewart Priest
print $add_to_db; Thanks for all your replies! I didn't expect to get one so quick, so thanks! After I did the above, I pasted the output into MySQL. Guess what? It didn't work! I was only sending values for $item1_desc and $item1_cost. Because I was not sending values for the other columns, I

Re: [PHP] Unable to send variables to MySQL table

2005-11-09 Thread Stewart Priest
What is the structure of that table? +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | invoice_no| int(10) | YES | | NULL| | | i