SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    John 8:24 JREAM's Avatar
    Join Date
    Sep 2007
    Location
    Florida
    Posts
    1,508
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    CURDATE or NOW no results

    With this query I do not understand why CURDATE or NOW do not input anything. The Row is set to DATE it appears as 0000-00-00

    PHP Code:
            $db->query("INSERT INTO $sqlcol SET
                `assign_user`='
    $assign_user',
                `to`='
    $to',
                `ticket`='
    $ticket',
                `status`='
    $status',
                `created`= CURDATE()"
    ); 

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,336
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    echo the sql string please, after the variable values have been substituted
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    John 8:24 JREAM's Avatar
    Join Date
    Sep 2007
    Location
    Florida
    Posts
    1,508
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Oh man after messing around so long I realized I was under the wrong file. Haha
    It works perfectly as expected now


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
  •