Last question I promise
I have set up a seperate table in my data base called 'my_build', I am trying to insert new data into this table .
I have written up what i though was the write code but i doesnt seem to be adding the data to the table, can you see any problems with the code?
<?php $con = mysqli_connect("localhost", "root", "", "Computers"); if ( isset($_POST['serial_no']) && isset($_POST['description']) && isset($_POST['price']) && isset($_POST['fname']) && isset($_POST['lname']) ) { $s = mysql_real_escape_string($_POST['serial']); $d = mysql_real_escape_string($_POST['description']); $p = mysql_real_escape_string($_POST['price']); //$sql = "INSERT INTO `my_build` (Serial_no, Description, Price) //VALUES ('$s', '$d', '$p')"; echo "<pre>\n$sql\n</pre>\n"; mysqli_query($con, "INSTER INTO `my_build` (serial_no, description, price) VALUES ('$s', '$d', '$p')"); echo 'Success - <a href="home.php">Continue...</a>'; return; } mysqli_close($con); ?> <p>Add A New User</p> <form method="post"> <p>Serial_no: <input type="text" name="serial_no"></p> <p>Description: <input type="text" name="description"></p> <p>Price: <input type="text" name="price"></p> <p><input type="submit" value="Add New"/> <a href="home.php">Cancel</a></p> </form>