RE: Getting the previous months documents

2006-05-02 Thread Peter Lauri
ntent']; $id=$row['id']; ?> Thanks for your help. - Original Message - From: "Peter Lauri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; Sent: Tuesday, May 02, 2006 10:20 AM Subject: RE: Getting the previous months documents >I did this, sorry

RE: Getting the previous months documents

2006-05-02 Thread Peter Lauri
nt or will I have to change the field to DATE? Ross - Original Message - From: "Peter Lauri" <[EMAIL PROTECTED]> To: Sent: Tuesday, May 02, 2006 9:06 AM Subject: RE: Getting the previous months documents > You should start by using MySQL date as the standard for

Re: Getting the previous months documents

2006-05-02 Thread ross
change the field to DATE? Ross - Original Message - From: "Peter Lauri" <[EMAIL PROTECTED]> To: Sent: Tuesday, May 02, 2006 9:06 AM Subject: RE: Getting the previous months documents You should start by using MySQL date as the standard for date: -MM-DD After t

RE: Getting the previous months documents

2006-05-02 Thread Peter Lauri
06-05-02 and order by that. /Peter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 02, 2006 3:04 PM To: mysql@lists.mysql.com Subject: Getting the previous months documents I have a database that stores documents relating to meetings. They have all

Getting the previous months documents

2006-05-02 Thread ross
I have a database that stores documents relating to meetings. They have all the usual stuff agenda, minutes etc. There are 3 paper types for each date agenda (1 only), minutes (1 only), and a bunch of general documents titled 'papers'. I need to display all the documents for a specific date whic