SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Guru
    Join Date
    Oct 2004
    Location
    uk
    Posts
    853
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    display timestamp different

    Hi guys
    My timestamp displays as 20070629104645

    I want it like this 29/06/2007

    Many thanks in advance

    PHP Code:


                  

    $sql 
    = ("select * from   jobs where category = '$category'"); 








                  
    $result mysql_query ($sql);

                  while (
    $row mysql_fetch_array($result))
                  {


      
    $title13 $row["startdate"];



    echo 
    "$title13";




  2. #2
    ✯✯✯ silver trophybronze trophy php_daemon's Avatar
    Join Date
    Mar 2006
    Posts
    5,284
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Code php:
    $sql = "select *, date_format(startdate,'%d/%m/%Y') startdate from  jobs where category = '$category'";
    Saul


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
  •