Re: Query Query
| From: | Daniel Clark | Date: | Sun, 30 May 2004 19:48:35 +0000 |
| Subject: | Re: Query Query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-187248@lists.php.net to get a copy of this message | ||
Can you send more of the code? I looks good so far.
>>This may be better suited to the MySQL lists, but I'd appreciate it if
>>someone could help. I'm probably just missing something stupid here but
>>have been coding non-stop for a week and need another set of eyes.
>>
>>Here's the line of code giving me an issue. I can print all the
>>variables in the script to screen and know that they're ok. It returns
>>successfully, but fails to update the database. I'm sure I'm about to
>>feel pretty stupid, so fire away... just please fire the answer too.
>>
>>$query="UPDATE $table_name SET company_name='$company',
>>first_name='$first_name', last_name='$last_name',
>>address='$address',
>>city='$city', state_province='$state', postal_code='$postal',
>>office_phone='$office', fax_phone='$fax', email='$email' WHERE
>>
>>company_name='$mod_dataset'";