RE: Getting the last entered row from a relational table

2003-06-05 Thread Andy Eastham
Try: select * from comments where (place_holder id) = (id in main table) order by id desc LIMIT 1 Andy > -Original Message- > From: Petre Agenbag [mailto:[EMAIL PROTECTED] > Sent: 05 June 2003 11:05 > To: [EMAIL PROTECTED] > Subject: Getting the last entered row from a r

Getting the last entered row from a relational table

2003-06-05 Thread Petre Agenbag
Hi List. I think I'm having a very off day and need some confirmations on how MySQL works with it's result sets. I have a couple of relational tables , the first holding the person's name and address for instance, and the other tables holds comments and complaints respectively. Each table has it'