|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
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
March 22nd, 2000, 08:56 PM
|
|||
|
|||
|
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
March 23rd, 2000, 08:45 AM
|
|||
|
|||
|
>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 |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
