Having trouble inserting $_POST into MySQL INSERT

[ratso]

Now I have turned Global variables off I am having trouble inserting my $_POST array into my database.

Does anyone have the correct syntax for inserting a $_POST array into a MySQL INSERT command?

echoing them works like this:

echo $_POST [whatever];

But when I insert them into a query like this:

$sqlquery = "INSERT INTO service_delivery
VALUES ('$POST[whatever]', '$POST [whenever]')";

It doesnt seem to work

Any wizend words of advice on offer?

Thanks

Ratso

[jburfield]

You could try this:

$sqlquery = "INSERT INTO service_delivery
VALUES (\"" . $_POST['whatever'] . "\", \"" . $_POST['whenever'] . \"")"; 

That should work.

OR, the easiest thing is this:

$value = $_POST["whatever"];

$sqlquery = "INSERT INTO service_delivery VALUES(\"" . $value . "\")";

-- Jason

[ratso]

Thanks Jason,

That worked a treat!!

🙂

[tha_mink]

or you could use extract() and just get plain variables