-
What, who, where am I?!?
Craig Lotter is a web developer based in Gordon's Bay, South Africa, who seems completely incapable of shaking off that pesky inner child within, the one that forces him to love all things animated or hand drawn.
The Rugged Rock of Craig contains snippets of his life, popular culture and all the important things like anime, manga, games and comic books. The CodeUnit of Craig on the other hand contains the more serious stuff like code snippets and tutorials, while the House of C chronicles his foray into the world of web comics.
For which it never seems he has enough time anyway.
CodeUnit Post Archive
Author Archives: Craig Lotter
jQuery DataTables with Lots of Columns Crashes in IE
If you are using the brilliant jQuery DataTables plugin to present your data in nifty dynamic tables, and are using it in a server-side loading context, you have no doubt encountered the issue when a table with a lot of columns (more than 20) fails to load (in other words stays in “processing” mode) when browsing using Internet Explorer (IE). Continue reading
How to Reuse a MySQL Result Set
To reuse an existing result set returned from a query is actually pretty simple thanks to PHP’s mysql_data_seek function and the fact that mysql_query returns a buffered result set by default.
Continue reading
Posted in MySQL, PHP
Tagged data seek, mysql, mysql_data_seek, PHP, result set, resultset, reuse
Leave a comment
IPCop: Troubleshoot No Internet when All other Network Activity Works
What’s the best way to try and troubleshoot the scenario when we have network connections to everything else but the Internet (i.e. external mail, MySQL, and FTP) works, on our IPCop run network? (And note in this case the IPCop run network usually runs perfectly fine, meaning we not delving into a setup that never worked before.)
Continue reading
Posted in Tutorials
Tagged advanced proxy, clear cache, internet connection, ipcop, troubleshoot
Leave a comment
MySQL: How to Check if a Column Exists in a Table with SQL
To check if a column exists in a table with SQL using a MySQL database is pretty easy, thanks to the nifty SHOW COLUMNS command.
Continue reading
MySQL: How to Check if a Table Exists with SQL
To check if a table exists with SQL in a MySQL database is pretty easy, thanks to the nifty SHOW TABLES command. Continue reading
