Thread: join 3 table?
View Single Post
Old 12-02-2008, 08:39 PM   #3 (permalink)
KingOfTheSouth
The Acquainted
 
KingOfTheSouth's Avatar
 
Join Date: Oct 2008
Location: Cincinnati
Posts: 151
Thanks: 14
KingOfTheSouth is on a distinguished road
Default

Code:
$get = mysql_query("
		SELECT 
			nrank,pimp,hoes,thugs,guests,rating,thugskilled,hoeskilled,Pimp.worth,status,
			Crew.icon
		FROM 
			$tab[pimp] Pimp LEFT OUTER JOIN
			$tab[crew] Crew ON Pimp.crew = Crew.id
		WHERE 
			Pimp.rid='$round' 
		ORDER BY 
			nrank ASC 
		LIMIT 50;"
	);
   while ($usr = mysql_fetch_array($get)){
That is something I pulled some of my code Is that more of what you are looking for? A Query that is jointed?
KingOfTheSouth is offline  
Reply With Quote