benardik Posted December 18, 2010 Share Posted December 18, 2010 Hi I am new to php and currently trying to allow users to update random fields of the table. I only have 5 fields in my table. this is my code so far... <?php $con = mysql_connect('localhost','root','password'); mysql_selectdb('myshop',$con); $r=$_POST['userid']; $test=array("['fname']", "['lname']", "['email']", "['username']", "['password']"); foreach ($test as $x =>$value); $query=("UPDATE users SET fname='$x WHERE userid = $r"); echo "Record Updated" ; ?> the HTML: <html> <body> <form method="post" action=noname3.php > <input type="text" name="userid" /> </br> <input type="text" name="fname" /> </br> <input type="text" name="lname" /> </br> <input type="text" name="email" /> </br> <input type="text" name="username" /> </br> <input type="text" name="password" /> </br> <input type="submit" name="submit" /> </br> </form> </body> </html> any sugestions??? Thanks Link to comment https://forums.phpfreaks.com/topic/222029-how-to-update-random-fiels-in-a-table/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.