Re: Re: What's wrong with this code?

Try concencating (however you spell it) the variables...i try not to put arrays inside of strings, rather i do the following below. Oh yeah, and you have two things that say VALUES (...) ...maybe ive missed this over the years, but i thought you put the fields inside parenthesis without anything before it, then you stick the VALUES() after it, like so: $sql = "INSERT INTO prod (Name, ShortDesc, LongDesc, PriceOZ, PriceLB, URLOX, URLLB, IMG) values('" . $_POST['Name'] . "','" . $_POST['ShortDesc'] . "...................)"; If you dont like using the concencating method, you could do this as well: $sql = "INSERT INTO prod (Name, ShortDesc, LongDesc, PriceOZ, PriceLB, URLOX, URLLB, IMG) values('{$_POST['Name']}','{$_POST['ShortDesc']}',.........)"; David Balatero me@davidbalatero.com ----- Original Message ----- From: "Shoulder to Shoulder Farm" <s2sfarm@peak.org> To: "PHP Database List" <php-db@lists.php.net> Sent: Monday, September 02, 2002 7.57 AM Subject: Re: [PHP-DB] Re: What's wrong with this code? > Sorry all, my mail program has been sending messages to the sender. > Sorry...Taj > > Jean-Christian Imbeault wrote: > > > Shoulder To Shoulder Farm wrote: > > > >> > >> mysql_query("INSERT INTO prod VALUES ( 'Name', 'ShortDesc', > >> 'LongDesc', 'PriceOZ', 'PriceLB', 'URLOZ', > >> 'URLLB', 'IMG') VALUES > >> ('$_POST[Name]', '$_POST[ShortDesc]', '$_POST[LongDesc], > >> '$POST[PriceOZ', '$_POST[PriceLB]', '$_POST[URLOZ]', > >> '$_POST[URLLB], > >> '$_POST[IMG]');") > > > > > > Maybe it's a typo but all you $_POST vars are wrong. They should be > > $_POST["var"] not $_POST[var] as you have them. > > > > Jc > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >