Jaribu this one <?php /* Connection string which i assume */ if($conn === false) { exit("<pre>" . print_r(sqlsrv_errors(), true) . "</pre>"); } if (isset($_REQUEST['action']) && $_REQUEST['action'] == 'add-entry') { $your variable a= $_REQUEST['formvalue a']; $your variable b= $_REQUEST['formvalue b']; $your variable c= $_REQUEST['formvalue c']; $sql = "INSERT INTO entries (a, b, c) VALUES (?, ?, ?)"; $stmt = sqlsrv_query($conn, $sql, array($your variablea, $your variableb, $your variablec)); if ($stmt === false) { echo "<p>An error has occured.</p>"; } else { echo "<p>New entry created.</p>"; } sqlsrv_free_stmt($stmt); } ?> <h2>title</h2> <form action="" method="post"> <div> <?php $sql = "SELECT * FROM (database).(table)"; $stmt = sqlsrv_query($conn, $sql); if ($stmt === false) { print_r(sqlsrv_errors()); } ?> <label>Project:</label> <select name="project"> <?php while($row = sqlsrv_fetch_array($stmt)) { echo "<option value=\"$row[id]\">$row[name]</option>"; } sqlsrv_free_stmt($stmt); ?> </select> </div> <div><label>a:</label> <input type="text" name="a" /></div> <div><label>b:</label> <input type="text" name="b" /></div> <div><input type="submit" value="Save" /></div> <input type="hidden" name="action" value="add-entry" /> </form> <?php sqlsrv_close($conn); ?> </body> </html>