ronnie88 Posted June 13, 2010 Share Posted June 13, 2010 <h1>Edit User</h1> <form action="admin.php" method="get"> Forum ID: <input type="text" name="id" /> <input type="submit" /> </form> <br><br><br> <h1>Add User</h1> <form action="add.php" method="post"> <input type="text" name="userid" size="20" /> Forum ID<br /> <input type="text" name="firstname" size="20" /> Member Name<br /> <select name="lastname"> <option value="Recruit.jpg">Recruit</option> <option value="Private.jpg">Private</option> <option value="Private-First-Class.jpg">Private 1st Class</option> <option value="Lance-Corporal.jpg">Lance Corporal</option> <option value="Corporal.jpg">Corporal</option> <option value="Sergeant.jpg">Sergeant</option> <option value="Staff-Sergeant.jpg">Staff Sergeant</option> <option value="Sergeant-First-Class.jpg">Sergeant 1st Class</option> <option value="Master-Sergeant.jpg">Master Sergeant</option> <option value="Sergeant-First-Class.jpg">1st Sergeant</option> <option value="Sergeant-Major.jpg">Sergeant Major</option> <option value="Command-Master-Sergeant.jpg">Command Sergeant Major</option> <option value="Warrant-Officer-1.jpg">Warrant Officer 1</option> <option value="Warrant-Officer-2.jpg">Warrant Officer 2</option> <option value="Warrant-Officer-3.jpg">Warrant Officer 3</option> <option value="Chief-Warrant-Officer.jpg">Chief Warrant Officer</option> <option value="Second-Lieutenant.jpg">2nd Lieutenant</option> <option value="Lieutenant.jpg">Lieutenant</option> <option value="Captain.jpg">Captain</option> <option value="Major.jpg">Major</option> <option value="Lieutenant-Colonel.jpg">Lieutenant Colonel</option> <option value="Colonel.jpg">Colonel</option> <option value="Brig-General.jpg">Brigadier General</option> <option value="Major-General.jpg">Major General</option> <option value="Lieutenant-General.jpg">Lieutenant General</option> <option value="General.jpg">General</option> <option value="General-of-The-Army.jpg">General Of The Army</option> <option value="Administrative-Advisor.jpg">Admin Advisor</option> <option value="Attorney-General.jpg">Attorney General</option> <option value="Chief-Recuiting-Officer.jpg">Chief Recruiting Officer</option> <option value="Secretary-of-Defense.jpg">Secretary Of Defense</option> <option value="Chief-Advisor.jpg">Chief Advisor</option> <option value="Chief-of-Staff.jpg">Chief Of Staff</option> <option value="Vice-President.jpg">Vice President</option> <option value="President.jpg">President</option> </select> <br /> <input type="text" name="xfire" size="20" /> Xfire<br /> <input type="submit" value="Store in database" /><input type="reset" value="Reset fields" /> </form> <br><br><br><br> <img src="how-to.JPG"/> <?php include 'db.php'; $userid = $_POST['userid']; $firstname = $_POST['firstname']; $lastname = $_POST['lastname']; $username = $_POST['xfire']; $url = '<a href="http://www.versionxgaming.com/forum/memberlist.php?mode=viewprofile&u='; $end = '">Forum Profile</a>'; $sql = mysql_query("INSERT INTO `users` (`userid`, `members`, `rank`, `xfire`) VALUES ('$userid', '$firstname', '$lastname', '$username')") or die(mysql_error()); mysql_query($query) or die("Query failed: " . mysql_error()); ?> I keep getting for some odd reason query was empty but it works just puts one to many in it doubles it Quote Link to comment Share on other sites More sharing options...
Alex Posted June 13, 2010 Share Posted June 13, 2010 $query is undefined. You're executing the query on the previous line: $sql = mysql_query("INSERT INTO `users` (`userid`, `members`, `rank`, `xfire`) VALUES ('$userid', '$firstname', '$lastname', '$username')") or die(mysql_error()); Quote Link to comment 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.