query($query); if ($conn->next_record()) $filename = (($conn->field_value("DOC_ID")) + 1).".jpg"; else $filename = "1.jpg"; if ($WITHDBINSERT == "1") { //---- insert new document if ($FILETYPE == "") $FILETYPE = "IMG"; $query = "INSERT INTO documents (DOC_FILE, DOC_LOC_ID, DOC_TYPE, DOC_CREATION_DATE)"; $query.= " VALUES (\"".$filename."\", '".$LOCID."', '".$FILETYPE."', now())"; $conn->query($query); $query = "SELECT LAST_INSERT_ID() AS MYID"; $conn->query($query); if ($conn->next_record()) $fileID = $conn->field_value("MYID"); } //---- display data print "filename=".utf8_encode($filename); print "&fileID=".$fileID; ?>