jenniferG Posted September 11, 2007 Share Posted September 11, 2007 The below query appears to not like the way we use timestamp. Thanks, Jennifer $ENTER_QUERY ="INSERT INTO SISTOCK( STOCK_INDEX, CAMERAMODEL, SERIALNUMBER, CONDITION, LOCATION, STATUS, ENTERED, TODAYDATE)VALUES( NULL, '$CAMERAMODEL', '$SERIALNUMBER', 'GOOd', 'SI', 'INSTOCK', '$ENTERDATE', timestamp(14) )"; Quote Link to comment https://forums.phpfreaks.com/topic/68853-query-with-timestamp/ Share on other sites More sharing options...
BlueSkyIS Posted September 11, 2007 Share Posted September 11, 2007 Assuming that is MySQL, use NOW() instead of timestamp(14), whatever that is. Quote Link to comment https://forums.phpfreaks.com/topic/68853-query-with-timestamp/#findComment-346074 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.