I'm trying to select all of the 'username' values from two tables.
So i can see whether the username is already taken.
Can anyone see what is wrong with this code? I keep getting "query 2 failed"
Thanks for your help.
$query2 = "SELECT * FROM user_info INNER JOIN submit1 ON user_info.username = submit1.username WHERE username='$usname'"; $result2 = mysql_query($query2) or die ("query 2 failed");