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