Well my code i started with is the one right at the start. The code i have now is [code] <?php session_start(); include "connect.php"; $username=$_SESSION['username']=$username; $username=($_POST['username']); $clantag=($_POST['clantag']); $clanname=($_post['clanname']); $clansite=($_post['clansite']); $username=addslashes($username); $clantag=addslashes($clantag); $clanname=addslashes($clanname); $clansite=addslashes($clansite); if (($_POST['clanname']=="") || ($_POST['clantag']=="")) { echo "Clan Tag and Clan Name are required fields."; }else{ $query = "SELECT * FROM clans WHERE clantag='$clantag' OR clanname='$clanname'"; echo $query; $result=mysql_query(query); while($row=mysql_fetch_assoc($result)){ if($row['clanname']==1) { echo "The Clan Tag or Clan Name you have chosen are allready in use."; }else{ $add_clan="INSERT INTO clans (clantag, clanname, clansite) VALUES ('$clantag', '$clanname', '$clansite')"; mysql_query($add_clan) or die(mysql_error()); $update_name="UPDATE users SET clanname='$clanname' WHERE username='$username'"; $result1=mysql_query($update_name) or die(mysql_error()); $update_tag="UPDATE users SET clantag='$clantag' WHERE username='$username'"; $result2=mysql_query($update_tag) or die(mysql_error()); $update_rank="UPDATE users SET rank='Leader' WHERE username='$username'"; $result3=mysql_query($update_rank) or die(mysql_error()); echo "You have sucessfully registered a clan"; } } } ?> [/code] I'm not sure if this code is doing the same as what the first bit of code was trying to do..