TalkPHP - View Single Post

delayedinsanity · 12-14-2009, 06:50 PM

mysql Code:

SELECT amount, status FROM table WHERE id >= ( SELECT id FROM table WHERE status = 'R' ORDER BY id DESC LIMIT 1 )

Something to that effect should help you get started.

12-14-2009, 06:50 PM	#4 (permalink)
delayedinsanity is cute and cuddly Join Date: Mar 2008 Location: Vegas, Baby Posts: 963 Thanks: 31	mysql Code: SELECT amount, status FROM table WHERE id >= ( SELECT id FROM table WHERE status = 'R' ORDER BY id DESC LIMIT 1 ) Something to that effect should help you get started.