[RESOLVED] join problems...

[zcollvee]

<?
include("head.php");
$query = "SELECT 'user' . 'username', 'user' . 'avatar' WHERE 'star' . 'username' = '".$id."' AND 'user' . 'username' = 'star' . 'friended' ORDER BY 'star' . 'fid'";
$result = mysql_query($query);
echo '<table><tr>';
while(list($username, $avatar) = mysql_fetch_row($result)){
echo '<td class="user"><a href="profile.php?username='.$username.'">
<img src="'.$avatar.'"><br />
'.$username.'</a></td>
';
}
echo '</tr></table>';
?>

ok. this is what its supposed to do. Take the username in the friends list (table called star) and get its avatar where the friends list is equal to the id of the current user on the site. what is wrong in this code?

[bradgrafelman]

First problem i notice is that you surround everything with single quotes in your query.

If you surround something with single quotes in a SQL query, it's considered a string. If you want to delimit a column/table/database/etc. identifer, you should instead use backticks (`).

[zcollvee]

nope still doesn't work

[NogDog]

I think you're looking for something like:

$query = "
   SELECT `user`.`username`, `user`.`avatar`
      FROM `user` 
         INNER JOIN `star` ON `user`.`username` = `star`.`friended`
      WHERE `star`.`username` = '" . $id . "'
      ORDER BY `star`.`fid`
";
$result = mysql_query($query) or die(mysql_error() . "<br />\n" . $query);

[zcollvee]

omg that was perfect thanks!