Is this possible?

I started working on this: http://ghastlycitysleep.com/index.php

I have a form where this band can enter info on their concerts and then it will be displayed in order on the site starting w/the earliest dated show. Well if they played yesterday, that info doesn't need to be on there anymore. Is there a way to have it display everything THAT DAY and after?

I hope I worded this in a way you can understand. I am still learning.

yes it is possible. but can you provide more information. like how you store the date in your database? in a timestamp or as it is?

Yes, if you pull the data from a MySQL database with something like

SELECT * FROM `concerts` WHERE `date` > CURDATE();

http://dev.mysql.com/doc/refman/6.0/en/select.html < check here for more details.

I can't get in to see how I have it set up. I THINK it is As Is.

Can I leave it that way and still do what I am trying to do or do I need to change it?

Originally Posted by aaricwon

I can't get in to see how I have it set up. I THINK it is As Is.

Can I leave it that way and still do what I am trying to do or do I need to change it?

no you don't need to change. you will just need to write the query depending on the way you use.

if you use timestamp your code should be

SELECT * FROM `concerts` WHERE `date` > CURRENT_TIMESTAMP();

if you use date as it is, then you should use the code rogem002 had written. it should work