On Friday 01 February 2002 02:42, Todd Williamsen wrote:
> It seems that my insert statement doesn't want to cooperate..  I used the
> same format as in Julie Meloni's book.  I know, sometimes, her code doesn't
> always work either.
>
> here it is:
>
> $sql = "INSERT INTO Jobs (id, Industry, Other, JobTitle, Description,
> Location, Date)
>  VALUES
>  (\"\",
>  \"$id\", \"$Industry\", \"$Other\", \"$JobTitle\", \"$Description\",
> \"$Location\", \"$Date\")";
>  $result = @mysql_query($sql) or die("OOPS!!  Couldn't Execute Query!");
>  ?>
>
> its not the whole code block... it dies and executes the "OOPS!!  Couldn't
> Execute Query!" statement.
> what is wrong... anybody?  Bueller?


Try using single quotes:

 $sql = "INSERT INTO Jobs (id, Industry, Other, JobTitle, Description,
 Location, Date)
  VALUES
  ('',
  '$id', '$Industry', '$Other', '$JobTitle', '$Description',
 '$Location', '$Date')";



-- 
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk

/*
To fear love is to fear life, and those who fear life are already three
parts dead.
                -- Bertrand Russell
*/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to