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) )"; 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. Link to comment https://forums.phpfreaks.com/topic/68853-query-with-timestamp/#findComment-346074 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.