PHP/mySQL question

Discussion in 'Web Design and Development (archive)' started by sonofslim, Nov 17, 2003.

  1. sonofslim macrumors 6502a


    Jun 6, 2003
    i've got a database that inserts records with a time field in the format MM/DD/YYY, instead of a standard timestamp. (i know, i know... but unfortunately i didn't write the original code.)

    i'm trying to pull the records back out via PHP with a statement like the following, based on a time i'm setting with an earlier form ($criteria_time):

    SELECT ab FROM table WHERE record_time '$criteria_time'
    and i've been playing with things like:

    $criteria_time date('n/j/Y', (mktime(000$month$day$year)));
    which puts my starting date into a format that matches the one in the database. but i'm having no luck in getting it to work; it just returns every record in the table. does anyone know how i should be doing this? i figure i need to tell mySQL to evaluate record_time and criteria_time as dates and not just strings, but i don't know how to do this.

    any and all help appreciated.
  2. cb911 macrumors 601


    Mar 12, 2002
    BrisVegas, Australia
    i can't answer your question, but i just wanted to mention that has video tutorials for PHP/mySQL. you can download them from that site after you've registered. i've got them on CD (haven't watched them yet) but all their VTM's are really good stuff.
  3. sonofslim thread starter macrumors 6502a


    Jun 6, 2003
    thanks for the tip!

    in case anyone is curious, the answer to my problem is to use a SUBSTRING(string, pos, len) in my query like so:

    SELECT blah FROM table WHERE 
    (SUBSTRING(record_date12) >= '$startmonth'
    AND (
    SUBSTRING(record_date42) >= '$startday')  AND(SUBSTRING(record_date74) >= '$startyear')
    which parses each bit of the date string separately.
  4. Rower_CPU Moderator emeritus


    Oct 5, 2001
    San Diego, CA
    Yup, I do something similar on my website to convert a timestamp to the "month, year" in the archives section in the left-hand column.

Share This Page