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

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@afan.net 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@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 >>> >>> >> > >