How do I get the next/top 5 events based on a date range?
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';
Last Comment
ASKER
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?
ASKER
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?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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;"
PHP
PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.
125K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
6 months from now: DATEADD(month, 6, GETDATE())