Jump to content

sasa

Staff Alumni
  • Posts

    2,804
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by sasa

  1. [!--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.)
  2. 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

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.