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 Link to comment https://forums.phpfreaks.com/topic/204647-query-failed-query-was-empty/ 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()); Link to comment https://forums.phpfreaks.com/topic/204647-query-failed-query-was-empty/#findComment-1071459 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.