Home » Archive for February, 2010

Failed To Read Auto-Increment Value From Storage Engine Error in MySQL. This is a very strange MySQL error. The error happens when trying to insert a new row in to a table. Basically this is a bug in MySQL that causes the problem but a work around is simple. The problem happens when the Auto-Increment value of a table grows beyond the limit. Just run...
Filed in: PHP/MySQL
When a form is submitted to the server, only selected values in a multiple SELECT box reaches the server. It is not possible to access the unselected options in a SELECT box from the server. Though this is not really required always, there are situations where you would want to access all the options in a SELECT tag. One example is, when you allow users...
This article basically talks about two things. 1) A Javascript code to move options from one multiple select box to another in a form. Move options from one SELECT box to another: There are two multiple SELECT boxes and one has got some OPTIONS in it. User can select one or more options from one and click on the Move button to transfer the selected...
PHP Encountered Access Violation at [some random memory address] Many of the guys who asked me about this problem faced it when trying to run PHPMyAdmin or other applications which access database, after setting up a local PHP environment on their machine under IIS. Try these fixes. Add your PHP path (the location of PHP files in your machine) to the...
Filed in: PHP/MySQL
Often, we come across situations where we need to INSERT multiple rows in to a database table from an Array, File or even from another Database Table. I am explaining various methods for inserting multiple rows using a single query using MySQL and PHP. MySQL documentation says you can use the following methods to speed up inserts: If you are inserting...

Page optimized by WP Minify WordPress Plugin