Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Php dates and recordsets

Php dates and recordsets

Thread began 2/25/2012 3:55 pm by newimage96814918 | Last modified 2/27/2012 9:51 am by newimage96814918 | 4516 views | 10 replies

2/27/2012 9:08 amnewimage96814918

I probably would'nt even need the date_format option like this then:
SELECT featured_shows.feature_id, featured_shows.event_id, featured_shows.feat_title, calendar_event.id, calendar_event.date_start FROM featured_shows, calendar_event WHERE DATE_FORMAT(calendar_event.date_start, '%Y-%m-%d') >= DATE_FORMAT(now(),'%Y-%m-%d')

If I was to use a join could I just use Date()?

I'm just not sure How I would join those?

You beat me to the post I'll try what you suggest and get back to you.

Tracy

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.