1 Code Snippet a Month Challenge
This was initially designed as a way for me to challenge myself in creating a code snippet every month that would be useful to online game development. I did pretty well at first but...
Tagged: snippets
MySQL & MSSQL Tutorial: Combine Multiple Rows Into A Single, Comma Delineated List
In MySQL with PHP: <? $delimiter = “, “; $count = 0; $loop = mysql_query(“SELECT S.suffix FROM people P INNER JOIN surnames S on P.suffix_id = S.id”) or die (‘cannot select merged data’); while...
PHP Tutorial: Learning PHP (Part 3)
In Part 2 I covered else-if statements and more complicated if statements. One of the other concepts that’s essential to learning any kind of programming is loops. There are three different types of loops...
PHP Tutorial: Learning PHP (Part 1)
When the Internet exploded in the .com age people were just starting to realize the potential of online programming languages. PHP, or Hypertext Preprocessing, is one of my favorite programming languages. One of the...
MSSQL Tutorial: Select All Tables & Fields
select table_name, column_name, data_type, character_maximum_length, is_nullable from information_schema.columns where table_name in (select name from sysobjects where xtype=’U’) order by table_name
Crystal Reports FIX: Formatting Numbers & String in Formula So It Doesn’t Have a Decimal
ToText(fieldname, 0, ”) + ” Your string of text here!”
