Archief - php: INNER JOIN

<?
// CONNECT
include('connect.php');

$SQL = "SELECT sweden_registery.nick as nick, sweden_post.text as text FROM `sweden_registery` INNER JOIN `sweden_post` ON 'sweden_registery.nick' = 'sweden_post.username'";
$SQL_GET = mysql_query($SQL);
while ($SQL_POST = mysql_fetch_object($SQL_GET))
{
$NICK = $SQL_POST->nick;
$TEXT = $SQL_POST->text;
?>
<!-- DIT IS DE OUTPUT -->
<table border="1">
	<tr>
		<td><?echo $NICK?></td>
	</tr>
	<tr>
		<td><?echo $TEXT?></td>
	</tr>
</table>
<!-- DIT IS DE OUTPUT -->
<?
}
?>

SELECT sr.nick, sp.text
FROM `sweden_registery` AS sr
INNER JOIN `sweden_post` AS sp 
     ON sr.nick = sp.username

$NICK = $SQL_POST->nick;
$TEXT = $SQL_POST->text;

SELECT sr.nick, sp.text
FROM `sweden_registery` AS sr
INNER JOIN `sweden_post` AS sp 
     ON sr.member_id = sp.member_id