Change your die() call to this:
die(mysql_error())
so you can actually see what is going on.
-Rasmus
On Mon, 20 May 2002, Php Developers wrote:
> This command just dies!
>
> I have checked sql connection ... ok
> the insert into line ... ok
>
> Pfft it just don't wanna work
>
>
> <?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')";
>
> echo $sql;
>
> mysql_query($sql) or die ("There has been an error");
>
>
> ?>
>
>
> ## Out put on page ##
>
> INSERT INTO prizeline (id, email, name, address, answers, date) VALUES ('',
>'[EMAIL PROTECTED]', 'newman', '12 Newman ave Auckland', 'In Season, James,
>John', 'Monday 20th of May 2002 10:22:05 AM')There has been an error
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
