Display records for 1 week

brattt

Hi. I need an SQL query to retrieve upcoming poker games from my database starting with today's games and including all other games for the next 7 days.
At the moment I have:

SELECT *
FROM tbl_todaysgames
WHERE WEEK(CURDATE()) = WEEK(date)
ORDER BY date ASC

which is not working.

Could anybody please guide me in the right direction

Thanks

bogu

This is probably not the best solution, but is suit your needs ...

$query = "SELECT * ";
$query.= "FROM tbl_todaysgames ";
$query.= "WHERE UNIX_TIMESTAMP(date) BETWEEN NOW() AND ".mktime(23,59,59,date('n'),date('j')+7);

kburger

Possibly a little simpler:

SELECT *
FROM tbl_todaysgames
WHERE date BETWEEN CURDATE() AND (date + INTERVAL 7 DAY)
ORDER BY date ASC

fasmy98

I've tried but it still showing the date after 7days.

I also have join with 2 table in my database.
I need help!

SELECT aktiviti.perkara as perkara,
Date_Format(tkh_aktiviti, '%d %b %Y') as aktivitidate,
aktiviti.hour as hour,
aktiviti.mnt as mnt,
aktiviti.pilihan as pilihan,
aktiviti.lokasi as lokasi,
aktiviti.anjuran as anjuran,
cawangan.keterangan as cawangan,
kakitangan.keterangan as kakitangan

FROM aktiviti,cawangan,kakitangan

WHERE aktiviti.cwgn = cawangan.kod AND aktiviti.kakitgn = kakitangan.kod AND tkh_aktiviti BETWEEN CURDATE() AND (tkh_aktiviti + INTERVAL 7 DAY)

ORDER BY tkh_aktiviti DESC

kburger

Oops, sorry. I just noticed a problem with the query I posted above. It should be:

SELECT *
FROM tbl_todaysgames
WHERE date BETWEEN CURDATE() AND (CURDATE() + INTERVAL 7 DAY)
ORDER BY date ASC

So assuming the rest of your query is correct, your query would be:

...AND tkh_aktiviti BETWEEN CURDATE() AND (CURDATE() + INTERVAL 7 DAY)