hehe sorry guys. I have a hard time explaining what im thinking when it comes to php and mysql. But i worked it out with no joins. i just did like this: [code] $query = mysql_query("SELECT * FROM ".$mysql['pre']."signups WHERE raid_id = ".$id) or die(mysql_error()); $i = 0; $name_exist = false; while ($row = mysql_fetch_assoc($query)) { if( $row['name'] == $_POST["name1"]) $name_exist = true;; } if( !$name_exist and $_POST["name1"] != "" ) { $query = mysql_query("SELECT name,guild_title FROM roster_members WHERE name = '$name1'") or die(mysql_error()); $guild_title = mysql_fetch_assoc($query); if ( count(mysql_fetch_assoc($query)) == 0) { $e = "Insert into ".$mysql['pre']."signups (name,class,guild,raid_id,text) VALUES ('".htmlspecialchars($_POST["name1"])."','".htmlspecialchars($_POST["class"])."','".htmlspecialchars($_POST["guild"])."',$id,'".htmlspecialchars($_POST["comment"])."')"; }else{ $e = "Insert into raidsign_signups (name,class,guild,raid_id,text,guild_title) VALUES ('".htmlspecialchars($_POST["name1"])."','".htmlspecialchars($_POST["class"])."','".htmlspecialchars($_POST["guild"])."',$id,'". htmlspecialchars($_POST["comment"])."','".htmlspecialchars($guild_title["guild_title"])."')"; }[/code] Thx for your help :) much appreciated [b]-OmiCron-[/b]