Re: Can someone check this mysql code
| From: | Kevin Waterson | Date: | Sun, 19 May 2002 21:25:11 +0000 |
| Subject: | Re: Can someone check this mysql code | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-98386@lists.php.net to get a copy of this message | ||
On Mon, 20 May 2002 08:57:16 +1200
"PhilipNZ Staff" <php@philipnz.com> wrote:
> My code below don't want to insert the code into the database what am I doing wrong?
>
> <?php
>
> $answers="$band, $middlename, $pot";
> $date=date ("l dS of F Y h:i:s A");
>
> $sql = "INSERT INTO
prizeline
> (id, email,
> name, address,
> answers, date) VALUES ('',
> 'email', 'name', 'address', 'answers',
> 'date');";
>
> $result = mysql_query($sql);
>
> ?>
>
$sql = "INSERT INTO prizeline (id, email, name, address, answers, date) VALUES ('',
'$email', '$name', '$address', '$answers',
'$date')";
echo $sql;
$result=mysql_query($sql) or die (mysql_error());
Kevin