In brief, to show the tables in a MySQL database, run the command:Continue reading
Here’s the path to DB file in CodeIgnitor admin end which contains query related stuff. Like building order, qhere and select blocks. One may want to do some debugging in this file. In this file i need to make no changes. Just for reference.
Now here’s how once could make a BETWEEN query for a date field. I wanted records for last 30 days. Continue reading