Msg#: 4152920 posted 1:51 pm on Jun 15, 2010 (gmt 0)
Do you mean the data in the "Bill" table has a TIMESTAMP and you want only those records returned with the TIMESTAMP of Monday and Thursday? Or do you only want to run the query itself on Monday and Thursday?
Msg#: 4152920 posted 2:01 pm on Jun 15, 2010 (gmt 0)
Have a look at the MySQL DAYOFWEEK [dev.mysql.com] function on the Date and Time Functions manual page. That should get you started. If you have difficulty constructing the rest of the query or run into other problems just post back here again.
Msg#: 4152920 posted 12:54 am on Jun 17, 2010 (gmt 0)
The sql query is not working for me pretty well. i'm facing problem having the emty data retrieved between 15-06-2010 and 16-06-2010 if today is not monday and thursday. i like my result to output only on my specific date if today are monday thursday otherwise the result should remained the same from last output Can you guys help me out please?
eg my mysql table with column as item and date. Only monday and thursday recorded