Query failed: Query was empty

[ronnie88]

<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

[Alex]

$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());