Jump to content

Archived

This topic is now archived and is closed to further replies.

spires

inner join help

Recommended Posts

Hi,

I'm trying to select all of the 'username' values from two tables.
tables:
user_info
submit1

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]

Share this post


Link to post
Share on other sites
Guest huey4657
$query2 = "SELECT * FROM user_info, [other table goes here]

and is

$usname spelt correctly?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.