Pastable version of Retrieve username by user ID from two different tables.

<pre class='prettyprint' language='php'>/**
 * am_getLatestHighScores
 *
 * 
 * 
 * 
 *
 * 
 */
	function am_getlatestscores($db, $cat) {
		$sql = &quot;SELECT * FROM `AMCMS_highscores` ORDER BY `primkey`='$id' DESC LIMIT 10;&quot;;
		$res = am_queries($db, $sql);
		return $res;
	}	
	
/**
 * am_latesthighscores
 *
 *
 */
	function am_latesthighscores($db = NULL, $wholelinked = NULL, $list = NULL) {
		global $db;
		$icounter = 0;
		$numcats = am_numArcademGameCat($db, NULL);
		$res = am_getlatestscores($db, NULL);
		if ($wholelinked == 'linkall') {$first = ''; $second= '&lt;/a&gt;';} else {$first = '&lt;/a&gt;'; $second= '';}
		if ($list == 'bracket') {echo '[ ';$bracket = ' | ';}
		while ($icounter &lt; $numcats) {
			if ($wholelinked!='none') {$numgamecat = ' ('.$res[$icounter][0].')';}
			if ($list == NULL &amp;&amp; $list != 'flat') {
				echo '&lt;li&gt;&lt;a href=&quot;index.php?cat='.$res[$icounter][1] ,'&quot;&gt;',$res[$icounter][1] , $first,$numgamecat,$second,'&lt;/li&gt;';
			} elseif ($list != 'bracket' &amp;&amp; $list != 'flat') {
				echo '&lt;a href=&quot;index.php?cat=',$res[$icounter][1] ,'&quot;&gt;',$res[$icounter][1] , $first,$numgamecat,$second;
			} elseif ($list == 'bracket' &amp;&amp; $list != 'flat') {
				echo '&lt;a href=&quot;index.php?cat=',$res[$icounter][1] ,'&quot;&gt;',$res[$icounter][1] , $first,$numgamecat,$second,$bracket;
			} 
			if ($list == 'flat') {
				$retvalue[$icounter] = $res[$icounter][1];
			}
			++$icounter;
			if ($icounter == $numcats-1) {$bracket = ' ]';} else {$bracket = ' | ';}
		}
			if ($list == 'flat') {
				return $retvalue;
			}
	}</pre>
<a href="http://www.refactormycode.com/codes/875-retrieve-username-by-user-id-from-two-different-tables" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://www.refactormycode.com/images/small_logo.gif" style="border:0" /></a>

Refactor :my => 'code'

Recent

Popular

Pastable version of Retrieve username by user ID from two different tables.