Archive | Programming & Code RSS feed for this section
How To Search For ID Values In A Different Worksheet With Excel VBA
This Excel VBA function allows you to take a column of values (e.g. ID numbers) in one worksheet, and use that to get corresponding values that are in a second worksheet. If you understand SQL, it’s something like: SELECT b.country FROM idtable as a, countrytable as b WHERE a.id=b.id I’ll explain the scenario further with [...]
Continue reading...Difference Between Integer Types in MySQL and Their Max Values
12. July 2011
In MySQL, there are 5 different integer types, and each type allows for different integer value sizes. In addition, each type can be signed or unsigned. If your value is always positive, then you can make your integer type unsigned. The following are the values that different integer types (signed/unsigned) can hold: Integer Type Start [...]
Continue reading...How To Reset The MySQL Root User Password and Privileges
26. January 2010
Problem: I was developing using PHPMyAdmin when I added a new root user (with a host value of %), and removed the rights of the default root user. When you do that, you’ll get a gut-wrenching feel that you just made a huge boo-boo, find that suddenly everything will not work, and kick yourself in [...]
Continue reading...Simple Way to Relay or Pass POST Data From A Page to Another Without .htaccess, Even Cross-Domain
25. August 2009
So I had a page which I absolutely could not change or rename. The challenge was, this page would normally receive POST data, and I had to pass or relay this POST data to another page, which resided on another domain. I tried .htaccess, but that didn’t work, so I figured that I had to [...]
Continue reading...Change WordPress Category / Archive Page From Full Content to Excerpt
4. June 2009
This problem was annoying me because WordPress themes may show the full content of every single post when you visit a category page or archives page, and I didn’t want that. I poked around the WordPress API and it turns out that you can just use a text editor (or the built in WordPress theem [...]
Continue reading...PHP Code to Detect IE Browsers
24. May 2009
The extremely buggy way that Internet Explorer renders CSS annoyed me again, this time because of the different way it displays elements with z-indexes. I spent a couple of hours trying to fix the bug, failed, and decided to go about it another way. The problem lay in a CSS/Javascript rotating banner gallery ,so I [...]
Continue reading...Htaccess Problem With HTTP Form Posts
22. December 2008
I had problems with my HTTP form posts working properly after implementing a htaccess script. The htaccess script basically redirects the non-www version of my website to the www version. However this caused problems with HTML form postings that posted to the non-www version, as the form postings would just go missing – as if [...]
Continue reading...
4. October 2011
0 Comments