MySQL Update

[nhwaldron]

I have a database that has 53 fields in it. I am trying to insert all data at once and can't seem to get it to work...

So, I inserted the first few fields. This works. However when I attempt to do and update (to insert the remaining fields) it doesn't work. Any suggestions? I have broken the "insert" up into 1 insert command and 5 updates.

Here is one of those updates:

$strUPDATE = "UPDATE orders SET osdistpd='HTTP_POST_VARS[osdispd]',multifocaltype='HTTP_POST_VARS[multifocaltype]',";
$strUPDATE = $strUPDATE."lensdesign='HTTP_POST_VARS[lensdesign]',material='HTTP_POST_VARS[material]',tint='HTTP_POST_VARS[tint]',";
$strUPDATE = $strUPDATE."other='HTTP_POST_VARS[other]',edging='HTTP_POST_VARS[edging]',eyesize='HTTP_POST_VARS[eyesize]',";
$strUPDATE = $strUPDATE."WHERE orderid=$myorderid";
$result = mysql_query($strUPDATE, $db);

Any help is greatly appreciated!

[Flameeyes]

$HTTP_POST_VARS not HTTP_POST_VARS.

[hand]

I think you forgot all the $ at HTTP_POST_VARS - definitions

<?
$strUPDATE = "UPDATE orders SET
	osdistpd        ='$HTTP_POST_VARS[osdispd]',
	multifocaltype  ='$HTTP_POST_VARS[multifocaltype]'
	lensdesign      ='$HTTP_POST_VARS[lensdesign]',
	material        ='$HTTP_POST_VARS[material]',
	tint            ='$HTTP_POST_VARS[tint]', 
	other           ='$HTTP_POST_VARS[other]',
	edging          ='$HTTP_POST_VARS[edging]',
	eyesize         ='$HTTP_POST_VARS[eyesize]',
		WHERE orderid=$myorderid"; 

$result = mysql_query($strUPDATE, $db)
	or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";
?>

[nhwaldron]

You are awesome! Thanks for the help!