INSERT inserts new data to database. If you want to update data, use UPDATE instead of INSERT.
Olavi Ivask I have been racking my brains trying to figure out what I am doing wrong. > i > have created a basic form that calls requests user information...the form > then runs insert.php. No errors are returned, however, my database does > not > update. Any suggestions? thanks > > The field names in the table are correct (case). > > > SUBMIT.HTML: > > <form action="insert.php" method="post"> > First Name: <input type="text" name="first"><br> > Last Name: <input type="text" name="last"><br> > Phone: <input type="text" name="phone"><br> > Mobile: <input type="text" name="mobile"><br> > E-mail: <input type="text" name="email"><br> > Web: <input type="text" name="web"><br> > > <input type="Submit" value="click para enviar"> > > </form> > > > INSERT.PHP > > <? php > echo"hello" > $username = "guest"; > $psswd = "password"; > $db = "contacts"; > $host = "localhost"; > > $first_name = $_POST['first']; > $last = $_POST['last']; > $phone = $_POST['phone']; > $mobile = $_POST['mobile']; > $email = $_POST['email']; > $web = $_POST['web']; > > mysql_connect($host,$username,$psswd) or die ("errror in access db"); > mysql_select_db($db); > > > > > mysql_query ("INSERT INTO users (First,Last,Phone,Mobile,Email,Web) VALUES > ('$first_name','$last','$phone,'$mobile','$email','$web') "); > > echo('$username','$last') > > echo mysql_error(mysql_connect($host,$username,$psswd)); > > ?> > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php