Hi,
I have a problem: I need to make a select for data that was entered
more than 24 hours ago, but in that 24 hours I have to count only Monday
- Friday since that is the working program, and does not have the status
= '2' ( Solved ) and the problem is that I sincerly do not know how.
Any help/suggestions are apreciated since I am just a beginner.
Best regards,
Cristi Stoica
P.S.: to give you a little idea on what I am using:
( the interface is coded in PHP for the users )
MySQL 4.0.24 and the the data looks like this:
+------------------------+---------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key |
Default | Extra |
+------------------------+---------------------+------+-----+---------------------+----------------+
| id | int(25) unsigned | | PRI |
NULL | auto_increment |
| client_name | varchar(100) | |
| | |
| code | bigint(13) | | |
0 | |
| status | varchar(13) | | |
0 | |
| date | datetime | | | 0000-00-00 00:00:00
| |
+------------------------+---------------------+------+-----+---------------------+----------------+
