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
> ('', '[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
 

-- 
 Jason Morehouse ([EMAIL PROTECTED])
 Netconcepts LTD - Auckland, New Zealand
 Linux: because rebooting is for adding hardware

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to