Show data from the last status = R

russellharrower · 12-11-2009, 10:27 AM

Hi I was wondering if anyone can help me, I need to be able to get information from my MYSQL database but only show the data that was added since the last status = R

for e.g.

Amount | Status
0.00 | R
1.90 | 0
1.40 | 0
0.00 | R
0.50 | 0

What I want it to show is 0.50

adamdecaf · 12-11-2009, 11:08 PM

Unless you have assigned each row an ID it will take pulling the whole db and then only using the last row. At least I think that's how you do it, there may be a MySQL command that I don't know about.

russellharrower · 12-14-2009, 04:33 AM

Yes each row has an id which is auto assigned.

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.