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
Tagged: Programming Languages
Useful PHP Functions
I ask myself why type the same thing over and over again when you can just use one function call? I’ve seen a lot of people do that, so stop it! Save yourself the...
Pits Of Doom Lesson 7: Join, Login & Lost Password
In the last lesson we created a database class to make doing queries quick and easy to handle. Then we converted over the current character file and map editor to use the database when...
Crystal Reports FIX: Error Occurred Reading Records: Subscript out of range
Okay, this threw me completely. Turns out I was telling Crystal Reports that I was going to pass 2 parameters and then I only passed one. This can also happen if you’re trying to...
Pits of Doom Lesson 6: MySQL Database Class
In the last lesson I introduced you to functions, reading & writing to a file, some simple javascript and adding features to the game so we could swap in/out maps and move up/down map...
Pits of Doom Lesson 5: Easy Map Editor
In the last lesson we made some real progress. Now, instead of having a boring page with a click of one button before the game is over, we have a character that can move...
Pits of Doom Lesson 4: And Array We Go
In the last lesson we covered how to create a function, how to use some of php’s built in functions, and how to deal with sessions. Now we’ll take it even a step further....
Pits of Doom Lesson 2: Breaking It Down
One of the best things to do if you’ve never made a game before or you don’t have much programming experience is to break things down into their most basic parts. We’ll start off...
Free Multiplayer PHP/MySQL Game — Pits of Doom
About a month ago I started giving someone PHP/MySQL lessons. In the lessons I made up a little game to teach the guy how to do different things in PHP all the way up...
Pits Of Doom Lesson 1: Planning Stage
Before you start any kind of online game you need to take a minute to sit down and consider some of the following questions: What is my game called? What is my target audience?...
