Tag Archives: SQL

MySQL Query – No Quote For String Fields

One of the module in our project, it is experiencing a slow performance. The module will let the user scan the PCB barcode of an item and updated a record on the database. It was originally built on MyISAM table … Continue reading

Posted in Database | Tagged , , , , , , | Leave a comment

From SQL Script to Zend Db Query

Yesterday, I have debugged an AJAX request that gets a value from the database. It was actually me who developed that module and all calculations and SQL query are based on the specifications given by our analyst. The query was … Continue reading

Posted in SQL, Zend Framework | Tagged , , , , | Leave a comment