Displaying and Replacing records

[ameslee]

I have displayed a certain amount of records on my site, how do i keep it up to date so that once a date passes; i am displaying events and dates; that one gets replaced with newer ones from the database. thanks!

 

[sleipnir214]

I'm not sure what you are asking, but it sounds to me like you need to use a SELECT query that pulls from the database records that fall into a certain data window.

I'll need more details about what you want to do and with what you are trying to do it before I can answer further.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[ameslee]

i am displaying events with dates on a website. I have limited how many records are to be displayed at once, i now want to know how i can keep these records up to date so that events that have passed do not show and are replaced with newer events from the database????

hope this makes sense, thanks

 

[Keendev]

on your sql statement, query those "events" and "dates" that are greater than the current date and use ORDER BY ASC on the date/time event on your sql statement, then output records in your page.

 

[ameslee]

can you give me an example of this, i have already got:
$query = "SELECT * FROM events ORDER BY Date"; date being my field and events being the table. Im not too sure how to do the greater than the current date thing.. thanks alot!