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 relational table > > > 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's own id field, as well as a > "master_id" that equals the id of the "main" table. > > The app that I'm writing (in PHP), lists the users with a simple "select > * from main" , and this returns all the users currently on the system ( > I have names as varchar and unique). > > My problem is now with the following: > > When the user clicks on one of the names, I want to do a couple of > things: > > a) The user details be displayed along with all the comments and > complaints that correspond to that users id located in the other tables. > pseudo SQL -> "select * from comments where (place_holder id in > comments) = (id in main table)"; > b) Being able to list the comments and complaints in reverse order ie, > older ones first: > pseudo SQL -> "select * from comments where (place_holder id) = (id in > main table) order by id desc"; > c) List ONLY the last (newest) comments/complaints > THIS IS WHERE I have problems: > > If I do a "select MAX(id), comment from comments where (place_holder id) > = (id in main table)" will MySQL automagically grab the comment from the > row that has the maximum ID? If so, is there a shorter way of doing this > query? For my example here, it's not a big deal, but with larger tables > with more collumns, having to specify the collumns in the query ( when I > want ALL to be returned) becomes a bit of a hassle.. > > I basically want to say: > > return ONLY the last comment added where the id matches the supplied id > from main_table. > > So, I need to Translate this to SQL... > > Can I do this with SQL, or must I first establish the id with the > "select MAX(id) from comments where id = provided_id", and then do a new > query " select * from comments where id = MAX(id) " > > Thanks > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
