•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 373,930 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,246 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 1476 | Replies: 3
 |
•
•
Join Date: Nov 2007
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
recently i created a system using php and mysql to record faults that the ict technicians could get reported faults out of. so far it does everything i want but some senior members of staff now want the front end to give a report of status, one of the things they wish to see is how many jobs have been completed this week month and year
within my tables is a field date. naturally it has the date submited contained within it. the code i have been using to try and get an output is
the complete feild is another contained within the datebase. i have also tried
unfortunatly my limited knowledge of php and sql is holding me back on this. any help guys would be appriacted
within my tables is a field date. naturally it has the date submited contained within it. the code i have been using to try and get an output is
mysql_query("SELECT date, datediff('day', date, CURRENTDATE) FROM softwarerepairtable WHERE datediff<= '7' and complete='yes' ");the complete feild is another contained within the datebase. i have also tried
SELECT * datediff('day', date, CURRENTDATE) FROM softwarerepairtable WHERE datediff<= '7' and complete='yes' ");unfortunatly my limited knowledge of php and sql is holding me back on this. any help guys would be appriacted
•
•
Join Date: Nov 2007
Location: Pretoria
Posts: 61
Reputation:
Rep Power: 1
Solved Threads: 3
Junior Poster in Training
It seems that you are selecting on the wrong check. You are saying that the function datediff should be less or equal to 7. This is not entirely correct. Perhaps you could try testing on the complete datediff result.
•
•
Join Date: Sep 2007
Location: Budapest
Posts: 251
Reputation: 
Rep Power: 0
Solved Threads: 12
Posting Whiz in Training
this is my own solution: try it. works for me
select * from mytable where
mydate BETWEEN date_format(Now() - INTERVAL 1 DAY,'%e/%c/%Y - %H:%i:%s') AND date_format(Now(),'%e/%c/%Y - %H:%i:%s') ";
this one sorts for 1 day.
if you need week, month, 45, 52 or 665 days
change this
Interval 1 to Interval 45
number is important....
to add dates change minus sign before interval 1
and 1 day would be added automatically.
select * from mytable where
mydate BETWEEN date_format(Now() - INTERVAL 1 DAY,'%e/%c/%Y - %H:%i:%s') AND date_format(Now(),'%e/%c/%Y - %H:%i:%s') ";
this one sorts for 1 day.
if you need week, month, 45, 52 or 665 days
change this
Interval 1 to Interval 45
number is important....
to add dates change minus sign before interval 1
and 1 day would be added automatically.
Last edited by fatihpiristine : Nov 2nd, 2007 at 9:57 am.
Do a favour, leave me alone
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Linear Mode
- Oracle Help Needed (Oracle)
- Any help would be appreciated (MySQL)
- Difference between 2 dates by month (MS Access and FileMaker Pro)
- Sorting in date order (Visual Basic 4 / 5 / 6)
- How do I calculate ages (MS SQL)
- Access DB Help: Tables (Visual Basic 4 / 5 / 6)
- ASP Date Help - If Then Else (ASP)
- calculate age (VB.NET)
- Querying within the results of a previous query? (MySQL)
Other Threads in the MySQL Forum
- Previous Thread: multiple search terms+fulltext search
- Next Thread: load data infile - fails to load my db2 del (ascii) file
