|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
May 29th, 2006, 04:14 PM
|
|||
|
|||
|
Show the latest data that was input? (noob)
Hey, I'm just starting to learn php/mysql, and I'm trying to do things that actually have a point, instead of trying with table: example, row: example1, example2, etc.
So basically what i'm doing is a checkbook balancing thing, where i have id, trans_date, trans_desc, credit, debit, balance. I need a way to grab the latest entry from balance so that i can add credit to it or subtract debit from it, then add a new entry with that updated balance with the date, description, etc.. So far I can only get the FIRST entry from balance, which doesnt help because i'd be adding/subtracting from the same amount. ive searched here, googled, etc, and I cant find anything, please help me out! Thanks
|
|
#2
May 29th, 2006, 04:27 PM
|
|||
|
|||
|
bah, im very n00b because i didnt figure to order by id descending, which gives me the latest balance, of course.
sorry for this post, i should have thought to try that first.
|
|
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > Show the latest data that was input? (noob) |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
