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?

Thanks
Dan

TP for good answers as usual

I don't think there's a simple and elegant way to do it, because MySQL compares string fields using the lexicographical order. That means that 01122007 (December 1st) will pe placed before 11012007 (January 11).
You should use the MySQL date format. It's simpler that way, because you have a bunch of usefull functions and procedures to get your job done. Look!
So try to convert the fields in your database, from strings (TEXT, VARCHAR) to dates (DATE, DATETIME).

what about if i just had three fields (day month year)

Could it be done if it was in that format?

Originally Posted by dansgalaxy

what about if i just had three fields (day month year)

Could it be done if it was in that format?

I think if you did that you'd have to write a special script just for that. I think it would be best to follow Tudor.B's advice and use MySQL to write the date in a database.

well i would also be writing a admin bit,
basically where it will be inputting entries and user can select the start and end date

Or more preferably, a start date and it automatically switches to the next one, on the next highest if the next highest date is >= current date.

so how could i do this with the mysql date thing.