hello i have a message table like this:
created datetime sender int recipient int message text to get all my messages i would do: select * from message where sender = $MYID or recipient = $MYID but how do i make a query that returns the rows of only the NEWEST messages between myself and my contacts (regardless of who sent the newest message)? i tried using "group-wise maximum" mentioned in the mysql manual, but can't figure it out. hope someone can help. thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
