12-02-2008, 07:39 PM
|
#3 (permalink)
|
|
The Acquainted
Join Date: Oct 2008
Location: Cincinnati
Posts: 151
Thanks: 14
|
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? |
|
|
|