Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Query with sub queries for forum flags work, but not entirely... can't figure out why

View all replies to this thread

Query with sub queries for forum flags work, but not entirely... can't figure out why

Thread began 6/19/2013 2:26 am by mrs | Last modified 6/19/2013 2:27 pm by mrs | 908 views | 4 replies

6/19/2013 10:46 amJason ByrnesWebAssist

dates are strings.

< or > arre mathematical operators for Less Than or greater Than.

you cannot perform Greater than or less than comparisons using strings

you can use UNIX_TIMESTAMP() to convert the date to a timestamp

for example:
SELECT UNIX_TIMESTAMP(fld_readsDATE) FROM ....

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.