|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
I'm working on a webpage that i would like to have autogenerated content, using PHP3 and MySQL. Basically, I would like it to pull information out of the database and post the date and title for the event, based on the current date on the server.
Does anyone know of a place where I could see this done? or have any sample code i could look at? thanks, dave. |
|
#2
|
|||
|
|||
|
>select event_title, event_date
>FROM event_table >WHERE to_days(now()) - to_days(event_date)=0 // [ORDER BY event_title|event_date] or whatever.... Assuming the event_date column is a valid date, time or timestamp datatype |
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > PHP3, MySQL - AutoGenerated Page by date |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|