I am doing some large timestamp-list iterations: Putting them in tables with date-ranges, and grouping them by ranges. In order to do that, I found strtotime() a very helpfull function, but I am worried about its performance. For example, a function that loops over a list of weeks (say, week 49 to 05) and has to decide the beginning of...
I downloaded the daterangepicker available here : filament group I am using jQuery 1.4.x version in my page, and all other plugins I am using are supported only on latest version of jQuery. The daterangepicker tool fails because it is using date.js (which uses a very old jQuery). If I use datepicker, all other plugins and functionali...
I am trying to build a table to show me the price of an item each day over a specified time period. I begin with three tables: one containing the sale price with a start and end date, one containing the regular price of an item and when it started at that price, and one date table that just has dates for filling in blanks. Tables: S...
Hi Can you please tell me why this works: $customer_data_date14daysAgo = mysql_query("SELECT COUNT(*) AS count FROM tableName WHERE datetime BETWEEN '$date14daysAgo%' and '$dateToday%' ") or die(mysql_error()); But this doesn't? $customer_data_date30daysAgo = mysql_query("SELECT COUNT(*) AS count FROM tableName WHERE datetime BE...