[Wierd MySQL Problem]

[!--quoteo(post=353158:date=Mar 9 2006, 06:41 AM:name=wickning1)--][div class=\'quotetop\']QUOTE(wickning1 @ Mar 9 2006, 06:41 AM) [snapback]353158[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Same for me, also Firefox 1.5.

The warning you're getting about the result is because the query is erroring out. Echo mysql_error() right after mysql_query() to see what the problem is.
[/quote]
try to change encoding of file Music.txt from 16-bit (UTF-16) to 8-bits (UTF-8). (You can do this with notepad.)

[find maximum date from table]

Good evening all.

 

I have a table that has a column called enddate and is of datatype date. (The dates will always be in the future.)

 

I would appreciate any help with the following:

 

1) The next date (in date terms - not table terms)

2) The maximum date

 

Can you please also advise how I get this to output to a browser.

 

Many thanks in advance

315128[/snapback]

1st

SELECT * FROM table_name ORDER BY enddate DESC LIMIT 1

2nd

SELECT * FROM table_name WHERE enddate>now() ORDER BY enddate ASC LIMIT 1