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
[EMAIL PROTECTED]
----- Original Message -----
From: "Shoulder to Shoulder Farm" <[EMAIL PROTECTED]>
To: "PHP Database List" <[EMAIL PROTECTED]>
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
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
