QUOTE(skyhawk133 @ Jun 11 2002, 02:50 PM)
I've looked at this statement for 30 minutes now... there is NOTHING wrong with it. But have a look... see anything messed up?
SQL
INSERT INTO retailers (id, company, name, address, city, state, zip, phone, url, description, lines, group, date_added, months, email) VALUES ('$company', '$name', '$address', '$city', '$state', '$zip', '$phone', '$addy', '$description', '$lines', '$group', '$today', '$months', '$email')
My boss did this and it works fine:
SQL
INSERT INTO `retailers` (`id`, `company`, `name`, `address`, `city`, `state`, `zip`, `phone`, `url`, `description`, `lines`, `group`, `date_added`, `months`, `email`) VALUES ('', '$company', '$name', '$address', '$city', '$state', '$zip', '$phone', '$addy', '$description', '$lines', '$group', '$today', '$months', '$email')
*shrugs* Strange how picky mySQL is.
| 