Re: can I do this: update table while selecting data from table?
| From: | Jochem Maas | Date: | Thu, 15 Jun 2006 06:19:48 +0000 |
| Subject: | Re: can I do this: update table while selecting data from table? | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-238029@lists.php.net to get a copy of this message | ||
afan@afan.net wrote:
> ?!?!?!?!?!?!
I hope youi used str_repeat() to generate that.
>>
>> seriously though, have you tried it?
>>
>> that said your [probably] better off just doing 1 query:
>>
>> UPDATE members SET member_name = 'N/A' WHERE member_name = '';
>>
>> that said your [probably] better off leaving the name empty or setting it
>> NULL if
>> it's unknown and showing 'N/A' in whatever output screen it's relevant
>> for
>> any
>> names that are found to be empty.
>>
>>> Thanks
>>>
>>> -afan
>>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>