How to Display only certain dates

[sampledformat]

Hey ,

I was wondering how you display fields between a certain timeframe.

For the moment i have

$query = "select * from shows where date >= current_date order by date";

which displays everything from the current date onwards.

i want to display the next two dates only.
It's for a shows page for a band and basically i want to display only the 2 upcoming shows in a small window.

Any clues?

Thanks

[chyan]

hope this work

$query = "select * from shows where date = (current_date +2 )";

[mourisj]

I think sampledformat wants the 2 next events starting from now, and these events can be any time, not necessarely on consecutive days !?

If ever you can add "2" to a date to the date incremented by 2, this would only be a solution if there is one event every day.

I suggest something like the following:

$query = "select * from shows where date >= current_date limit 0, 2";

JJ Mouris

[devinemke]

$today = date('Y-m-d');
$today_plus2 = date('Y-m-d', time() + 86400);
$sql = "SELECT * FROM shows WHERE date BETWEEN '$today' AND '$today_plus2'";