SQL query Where Between two input

I am trying to make a search box but I am facing an issue. Here's the query i am using, I am getting the search query from database,But query is not taking the Fiyat(price),meterekare,odasayisi values from database My question is that Why I am unabl...
more »

2017-01-06 22:01 (0) Answers

SQL Between query not work properly

SELECT * FROM `incomes` WHERE incomeDate BETWEEN '28-12-2016' and '31-01-2017' This query not work but When i do below query it show result SELECT * FROM `incomes` WHERE incomeDate BETWEEN '28-12-2016' and '31-12-2016' ...
more »

2017-01-02 05:01 (2) Answers

PHP list files in directory between time X and Y

I'm running a Raspberry Pi with two cameras attached to it, capturing photos every 5 minutes 24/7 for daily timelapse videos. What I'm trying to accomplish right now, is an option to filter out the night photos. The photos are stored in the format YY...
more »

2016-12-13 21:12 (0) Answers

Query - Between operator on PHP ADODB

I have a form with two datepicker (dd/mm/yyyy). Code: <label for="from">From Date:</label> <input type="text" id="from" name="from"> <label for="to">to Date:</label> <input type="text" id="to" name="to"> And...
more »

2016-11-07 11:11 (1) Answers

Mysql query date between in large table

my query is running about 10 seconds and that's unacceptable. I am looking for a way to improve this speed but i'm out of options. I have to find the records between now and 30 days back in a table over 12 million rows. The following query: SELECT...
more »

2016-11-02 11:11 (1) Answers

Where Clause - Between Condition Error

I'm trying to work on my query below on I have most of it right, but for some reason my BETWEEN condition is not working when trying to filter out the dataset...it doesnt filter it at all. Can anyone take a look at my code below and let me know what ...
more »

2016-10-17 23:10 (1) Answers

sql date-time comparison of people

I want to make a list of people when they are working without a chef. sql table: people_id clock_in clock_out 1 2016-10-10 06:58:01.000 2016-10-10 14:59:01.000 1 2016-10-11 06:57:02.000 2016-10-11 14:58:23.000 .. 2 ...
more »

2016-10-11 16:10 (1) Answers