RE: Date and Mysql...

2002-04-10 Thread Christian Pfeiffer
Hi again... Hi, When I felt proud because last week I had asked about how to use NOW(), and get answer that got me working, but now I have a strange problem. It listing dates, but it not listing like it should, when the web page is create it going 9, 8, 5, 10 on the dates. Here is

FW: Date and Mysql... (now complete)

2002-04-10 Thread Christian Pfeiffer
(one should not mess up strg and shift :-/) Hi again... Hi, When I felt proud because last week I had asked about how to use NOW(), and get answer that got me working, but now I have a strange problem. It listing dates, but it not listing like it should, when the web page is create

RE: 2 queries in one?

2002-01-02 Thread Christian Pfeiffer
Should be something like Select Status, Date from Table where Status closed or Date now() - 14 (This is from memory so please dont rely on the syntax ;-) HTH, Chris -- Christian Pfeiffer Smart-Link Gesellschaft für EDV-Systemlösungen mbH Herforder Str. 5-7 www.smart-link.de