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.
/administrator/system/database/DB_active_rec.php
Now here’s how once could make a BETWEEN query for a date field. I wanted records for last 30 days. Continue reading
While working on a web links directory i wanted to update categories table’s num_listings column with the count of listings under each category. The category id was stored something like this in listings table: Continue reading
Just a few notes on joining a MySQL table to itself to get unique combination of data stored in its fields.
Suppose we have a MySQL table named `keywords` having fields `word1`, `word2` and `word3`. Once we have got a few records inserted into this table we would want to show all possible combination of keywords stored in those fields. For example, a select query returns a following set of data: Continue reading
Having WAMP installed when i try to type mysql in my windows command prompt it would give me the following error: Continue reading
Yesterday i had a somewhat new (for me ) and different kind of requirement while displaying MySQL result on a page. I had a category menu in which masters and slaves were sorted alphabetically and in ascending order. Continue reading
Normally, most of us use “SELECT * FROM table WHERE field1 LIKE ‘%$keyword%’” OR field2 LIKE ‘%$keyword%‘ ..etc” to search our table and get results. This is slow and inefficient approach, as it does return all (too many) rows in which it does find a match for “keyword” without caring for “relevancy” and time. Continue reading
Recent Comments
Arvind Thakur on Simple image rotater with fadeIn fadeOut effect using jQuery
Found even more-more precised and simplest method at Jonathan Snook's blog with a demo. I am sure nothing can be...anil kiumar on Resume download of PART extension file in Firefox
yah bepsait acchi haiArvind Thakur on Simple captcha component for CakePHP 1.x
CakePHP 2.x version of this component is hereArvind Thakur on Resume download of PART extension file in Firefox
As i did not had access to website i tried to reply you last night through email address you posted...sophia on Resume download of PART extension file in Firefox
Hi, I have only part file and I made a copy of it by removing .part. later I moved it to another...