On 24-Jul-2001 Jeremy Morano wrote:
> Whats wrong with this?
>
>
> $sql = "INSERT INTO $table_name
> (uid,companyUid, first_name, last_name, address, state, zip_code, country,
> company, occupation, telephone, fax, email, user_name, password)
> SELECT
> \"\", \"uid from companyTable WHERE company= "Itsolutions"\,
> \"$first_name\",\"$last_name\",\"$address\",\"$state\",\"$zip_code\",\"$coun
> try\",\"$company\", \"$occupation\", \"$telephone\", \"$fax\", \"$email\",
> \"$user_name\", \"$password\"
> ";
>
A. It's un-readable.
B. you prolly did'nt test | display the error message.
Change your \" to ' and the problem is obvious
(spoiler: 'WHERE' comes after the field list).
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
PHP General 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]