SitePoint Sponsor

User Tag List

Page 2 of 2 FirstFirst 12
Results 26 to 29 of 29
  1. #26
    SitePoint Evangelist
    Join Date
    Mar 2006
    Posts
    407
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    how can i do that?....sorry, you know im a bit thick!

  2. #27
    Theoretical Physics Student bronze trophy Jake Arkinstall's Avatar
    Join Date
    May 2006
    Location
    Lancaster University, UK
    Posts
    7,062
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    lol.

    Anyway, I mean some of the data returned by the query. To do that, use PHPMyAdmin and run the query through it, then paste the results.

    Thanks,
    Jake Arkinstall.
    Jake Arkinstall
    "Sometimes you don't need to reinvent the wheel;
    Sometimes its enough to make that wheel more rounded"-Molona

  3. #28
    SitePoint Evangelist
    Join Date
    Mar 2006
    Posts
    407
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    will this surfice?
    Attached Images Attached Images

  4. #29
    Theoretical Physics Student bronze trophy Jake Arkinstall's Avatar
    Join Date
    May 2006
    Location
    Lancaster University, UK
    Posts
    7,062
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    That's great.
    Here you go - this should work. I originally assumed that mindate and maxdate held timestamps (the amount of seconds since jan 1st 1970).
    PHP Code:
    $dateformat "l jS F, y";
    $min strtotime($row_Recordset2['mindate']);
    $max strtotime($row_Recordset2['maxdate']);
    $minform date($dateformat$min);
    $maxform date($dateformat$max);
    printf("<p>%s%s</p>"$minform, (($max $min) ? " - " $maxform "")); 
    Jake Arkinstall
    "Sometimes you don't need to reinvent the wheel;
    Sometimes its enough to make that wheel more rounded"-Molona


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •