spires Posted August 30, 2006 Share Posted August 30, 2006 Hi, I'm trying to select all of the 'username' values from two tables. tables:user_infosubmit1 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.[code] $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");[/code] Quote Link to comment Share on other sites More sharing options...
Guest huey4657 Posted August 30, 2006 Share Posted August 30, 2006 $query2 = "SELECT * FROM user_info, [other table goes here]and is$usname spelt correctly? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.