Re: Why would this command just Die!
| From: | Jason Morehouse | Date: | Sun, 19 May 2002 22:41:26 +0000 |
| Subject: | Re: Why would this command just Die! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-98391@lists.php.net to get a copy of this message | ||
To see the actual error try: "or die (mysql_error())".
On Mon, 20 May 2002 10:27:20 +1200, 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
> ('', 'newmanpj@philipsdomain.com', 'newman', '12 Newman ave
> Auckland',
> 'In Season, James, John', 'Monday 20th of May 2002 10:22:05 AM')There
> has been an error
--
Jason Morehouse (jm@netconcepts.com)
Netconcepts LTD - Auckland, New Zealand
Linux: because rebooting is for adding hardware