http://novicecoder.com Coding tips I wish I had known earlier... Sun, 20 Aug 2006 06:24:36 +0000 http://backend.userland.com/rss092 en Pretty obvious, but I had to look it up so I figured I should save it here. Say I misspelled "people" as "peeple" and I wanted to fix them all in my database. Just do: UPDATE table SET field=REPLACE(field, 'peeple', 'people' ); http://novicecoder.com/site-info/find-and-replace-in-sql-tables In going from an html form to php code and finally to a sql query there are a lot of steps that could get messy, but fortunately php has a simple way to do this all. Let's say I have some checkbox options on my html form for a ... http://novicecoder.com/php/implode-checkbox-group-arrays-into-query-strings Some of us like to keep our lines under 80 characters wide (and some are forced to by coding standards). Either way, it's a little bit easier to keep track of it with a guide line denoting the margins. Just modify the registry and create a string value ... http://novicecoder.com/ides/visual-studio-margin-guide-lines Regular expressions (regex) are used in many situations. Web server administration and search algorithms are just a couple of the tasks where I've found myself looking up references on them. Rather than always searching for the latest search engine optimized page on the internet, I figure I should ... http://novicecoder.com/general/regular-expressions In any language, you'll often find yourself working with arrays. PHP offers a couple methods for adding items to them. Say you have an array: $arrayvals = array("elton", "sam"); and you want to add the value, "shaun" to it. You can either do: $arrayvals[] = "shaun"; or you can do: array_push($arrayvals, "shaun"); So ... http://novicecoder.com/php/better-array-pushing Do you have lots of places in your code where you do: if (stringval == null || stringval.Length == 0) { handle string... } Well, .NET 2.0 adds a static method to the string class for IsNullOrEmpty. So now you can just test against string.IsNullOrEmpty(stringval) and save yourself a few keystrokes. http://novicecoder.com/c/faster-string-testing This is my log for random coding things that make life easier. Most things won't be too technically advanced, but rather buried features that might not be obvious. They're typically things I've learned by writing some long method and having someone else come along and ask why I ... http://novicecoder.com/site-info/purpose