silverglade Posted October 20, 2009 Share Posted October 20, 2009 hi, i have the following script which is supposed to update the table in the database, and output the results of the newly inserted data to the same page. it doesnt work. please if anyone can tell me why, id greatly appreciate it. here is the code <?php include("connect1.php"); //////////////////////////////////////// //////////////////////////////////////// /// query db and loop through rows example $field2 = $_POST['username']; $field3 = $_POST['password']; $field4 = $_POST['Name']; if(isset($_POST['Submit'])){ //if submit has been set, or clicked. if($field2 && $field3 && $field4){ mysql_query("INSERT INTO table2 (username,password,name)VALUES('$field2','$field3','$field4')"); }else{ echo "error"; } }//isset //////////////////////////////////////////////////////////output data into a table/////////////////////////////// $query = mysql_query("SELECT * FROM table2"); $table = "<table width=\"40%\" border=\"1\"> <tr> <td>ID</td> <td>username</td> <td>password</td> <td>Name</td> </tr>"; while($row = mysql_fetch_array($query)){ $table .= " <tr> <td>".$row['record_id']."</td> <td>".$row['username']."</td> <td>".$row['password']."</td> <td>".$row['Name']."</td> </tr>"; } $table .= "</table>"; echo $table; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Derek's secret account updater</title> </head> <body> <form id="form1" name="form1" method="post" action="secret_updater.php"> <table width="31%" border="0"> <tr> <td colspan="31%">Derek's secret Account updater</td> </tr> <tr> <td width="32%">username:</td> <td width="68%"><input name="username" type="text" id="username" /></td> </tr> <tr> <td>password:</td> <td><input name="password" type="text" id="password" /></td> </tr> <tr> <td>Name:</td> <td><input name="Name" type="text" id="Name" /></td> </tr> <tr> <td><input type="submit" value="Submit" /></td> </tr> </table> </form> </body> </html> Quote Link to comment https://forums.phpfreaks.com/topic/178384-cant-update-my-table-in-the-db/ Share on other sites More sharing options...
abazoskib Posted October 20, 2009 Share Posted October 20, 2009 try this: mysql_query("INSERT INTO table2 (username,password,name) VALUES('$field2','$field3','$field4')"); Quote Link to comment https://forums.phpfreaks.com/topic/178384-cant-update-my-table-in-the-db/#findComment-940709 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.