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)
> \"$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,
'$id', '$Industry', '$Other', '$JobTitle', '$Description',
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
To fear love is to fear life, and those who fear life are already three
-- 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]