query($query); if($result) { $dataArray = $result->fetch_assoc(); $key= $dataArray['word_id']; $query = "INSERT INTO recordings (when, word_id, filename) VALUES (NOW(), $key, $fileName)"; $result = $mysqli->query($query); } $mysqli = new mysqli("$DBHOST","$DBUSER","$DBPASS","$DBBASE"); $query = "SELECT word_id FROM words WHERE word='$_GET[word]'"; $result = $mysqli->query($query); if($result) { $dataArray = $result->fetch_assoc(); $key= $dataArray['word_id']; $query = "UPDATE words SET last=NOW() WHERE word_id='$key'"; $result = $mysqli->query($query); } $mysqli->close; } // // GET WORD // $WORD = ""; $mysqli = new mysqli("$DBHOST","$DBUSER","$DBPASS","$DBBASE"); $query = " SELECT * FROM ( SELECT * from words ORDER BY last ASC LIMIT 5 ) as options ORDER BY RAND() LIMIT 1 "; $result = $mysqli->query($query); if($result) { $dataArray = $result->fetch_assoc(); $WORD = $dataArray['word']; } $mysqli->close; ?> ' ?> Thank you for calling. Repeat the words you hear. Hang up when you are done. ?word=" method="POST" maxLength="10" recordingStatusCallback="http://coldshadow.com/twilio/poi/saverecording.php?word=" timeout="3" />