Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
Solved
How do I get the next/top 5 events based on a date range?
Posted on 2012-12-21
I have a database of events for the next 12 months.
How do I query the top 5 events based on today's date for the next 6 months?
What is the syntax for the today's date and six months from now?
I've tried this:
$query = 'SELECT TOP 5 date
,startTime
,endTime
,title
,details
,room
FROM
WWW.dbo.Events
WHERE date BETWEEN (today) and (six months from today)
ORDER BY date DESC';
How do I query the top 5 events based on today's date for the next 6 months?
What is the syntax for the today's date and six months from now?
I've tried this:
$query = 'SELECT TOP 5 date
,startTime
,endTime
,title
,details
,room
FROM
WWW.dbo.Events
WHERE date BETWEEN (today) and (six months from today)
ORDER BY date DESC';
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
3
6 Comments
when I do that it says:
Notice: Array to string conversion
how would I use the dates in the query above?
Notice: Array to string conversion
how would I use the dates in the query above?
ok, I can get the dates I need in the proper format this way:
$today = date("Y-m-d");
echo $today;
$sixmonths = mktime(0,0,0,date("m"),dat
echo "<br>Six Months is ".date("Y-m-d", $sixmonths);
but when I add them to my query they say they are not columns?
$today = date("Y-m-d");
echo $today;
$sixmonths = mktime(0,0,0,date("m"),dat
echo "<br>Six Months is ".date("Y-m-d", $sixmonths);
but when I add them to my query they say they are not columns?
Should be the following:
SELECT TOP 5 date ,startTime ,endTime ,title ,details ,room
FROM WWW.dbo.Events
WHERE date BETWEEN GETDATE() and DATEADD(month, 6, GETDATE())
ORDER BY date DESC';
SELECT TOP 5 date ,startTime ,endTime ,title ,details ,room
FROM WWW.dbo.Events
WHERE date BETWEEN GETDATE() and DATEADD(month, 6, GETDATE())
ORDER BY date DESC';
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name '$today'.' in C:\inetpub\wwwroot\db2.php
Doing it that way:
$query = "SELECT TOP 5 date, startTime, endTime, title, details, room
FROM WWW.dbo.Events
WHERE date BETWEEN '" . $today . "' and '" . $sixmonths . "'
ORDER BY date DESC;"
$query = "SELECT TOP 5 date, startTime, endTime, title, details, room
FROM WWW.dbo.Events
WHERE date BETWEEN '" . $today . "' and '" . $sixmonths . "'
ORDER BY date DESC;"
Featured Post
Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Foreword (July, 2015)
Since I first wrote this article, years ago, a great many more people have begun using the internet. They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
Originally, this post was published on Monitis Blog, you can check it
here
.
In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions.
Consider email address RFCs:
Look at HTML5 form input element (with type=email) regex pattern:
T…
The viewer will learn how to count occurrences of each item in an array.
Suggested Courses
Course of the Month4 days, 10 hours left to enroll
661 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.