Joined Queries?

[3raser]

Here is the original query:

 

$query_extract = mysql_query("SELECT downloads,date,title,username,views,id FROM skins ORDER BY id DESC LIMIT 100");

 

Is it possible to also grab the row username from the table users, without making multiple queries?

[Zurev]

Give this a shot:

 

SELECT s.downloads,s.date,s.title,s.username,s.views,s.id FROM skins s, users u WHERE s.username = u.username ORDER BY s.id DESC LIMIT 100

 

Dusty on my SQL, may not work...

[3raser]

I tried this:

 

	$query_extract = mysql_query("SELECT s.downloads,s.date,s.title,s.username,s.views,s.id,u.status,u.username FROM skins s, users u WHERE s.username = u.username ORDER BY s.id DESC LIMIT 100");

	while($row = mysql_fetch_assoc($query_extract))
	{
		if($row['u.status'] == 1) $row['s.username'] = "dgjldfgjdflg";
		echo "<tr><td><img src='skins/". $row['id'] .".png'></td><td><a href='view.php?id=". $row['id'] ."'>". $row['title'] ."</a></td><td>". $row['username'] ."</td><td>". $row['date'] ."</td><td>". $row['downloads'] ."</td><td>". $row['views'] ."</td></tr>";
	}

 

Yet, the user's name doesn't change. :/