09-23-2007
|
| Administrator
Join Date: Jun 2007
Posts: 3,729
BRL$: 31,920.85 Thanks: 0
Thanked 4 Times in 4 Posts
Rep Power: 403 | |  Mysql how to get the next highest to a value?
hi, i have been looking about and cant seem to find a answer so i thought i would ask you lot! ok, i have a table which has dates in like 20092007 (20/09/2007) and i can use the max() in mysql to get the highest but how can i select the next highest value so if i have $cur_date and i want to select the date from the db which is the next highest when compared to $cur_date Does this make sense? ThanksDan TP for good answers as usual
To view links or images in this forum your post count must be 1 or greater. You currently have 0 posts.
To view links or images in this forum your post count must be 1 or greater. You currently have 0 posts.
| |
__________________
█ High Quality
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
█ Powerful
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
█
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
| | | |
