Re: can I do this: update table while selecting data from table?
| From: | afan at afan dot net | Date: | Thu, 15 Jun 2006 12:53:51 +0000 |
| Subject: | Re: can I do this: update table while selecting data from table? | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-238082@lists.php.net to get a copy of this message | ||
I wonder why this sarcasm? Why so rude?
-afan
> 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
>>>
>>>
>>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>