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]