INNER JOIN display info on the web

[Pain]

Hello.

 

I am trying to display info from two tables with this code.

 

<?php

$query = mysql_query("SELECT users.username, users2.username FROM users INNER JOIN users2 ON users.id = users2.id");
$numrows = mysql_num_rows($query);

if ($numrows != 0)

{
while ($row = mysql_fetch_assoc($query))
{
	$username = $row['username'];
	echo $username . "<br />";

}

}


?>

 

However it displays info only from one db (users). I suppose there's something wrong with

<?php
...
while ($row = mysql_fetch_assoc($query))

{
	$username = $row['username'];
	echo $username . "<br />";

}
...
?>

 

Any help will be appreciated. Thank you.

[jeff5656]

"$username = $row['username'];"

 

the query doesn't know which table this refers to.

you have to say select users.username as username1, users2.'usersname2'as users2...

ans then in the while look say $row[username1] or $row['usersname2']

[jeff5656]

Also put mysql_query($query) or die(mysql_error());

so the error will tell you what the problem is. 

[Pain]

Than you! That helped.