Re: can I do this: update table while selecting data from table?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Jochem,
You are wrong. I tried and it worked. But, when I asked "can I", I meant
"Am I allowed to do that". The same as many security or other kind
questions where answer is: Yes, it works - but it's NOT correct.

Yes, I did search php.net but didn't find answer.
Yes, I did search mysql.com but didn't find answer.
(Hm, maybe I had to spend few more days before I'm ALLOWED to post a
question here)

And, please, if you DON'T WANT to help - don't answer at all. Believe me,
your kind of answer REALLY do not help. Contrary, brings this kind of
"conversation" what this great group really doesn't need.

Thanks.

-afan




> afan@xxxxxxxx wrote:
>> I wonder why this sarcasm? Why so rude?
>
> your original question could have been answered by:
>
> a, trying to run the code provided (thats called testing btw)
> b, reading php.net
> c, reading mysql.com/docs (or where ever they have the docs this week)
>
> my reply not only contained the blantantly silly suggestion that you
> had to reboot the machine but also seriously asked if you had tried to run
> the code (I can garantee that you had not because then you would have know
> that it did work with out posting here) AND I offered 2 suugestions as to
> why the strategy you were employing for the routine sucked - one
> performance
> related, one with regard to DB/data theory.
>
> and all you could come up with as a response was '?!?!?!?!?!?!'
>
> you want spoonfeeding, try kindergarten.
>
>>
>> -afan
>>
>>
>>> afan@xxxxxxxx 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
>>>
>>>
>>
>
>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux