Coder Forum

PHP Quellcode

function getTextMYSQL($identfier) {
	$sql = "SELECT * FROM mitglieder ORDER BY userid DESC LIMIT 0,2";
	$res = mysql_query($sql);
	$text = "";
	while($row = mysql_fetch_array($res)) {
		$text .= '<a href="'.$row['userid'].'">'.$row['username'].'</a>';
	}
	return $text;
}

Source code

              $sql = "SELECT * FROM mitglieder ORDER BY RAND() LIMIT 0,2";
        $res = mysql_query($sql);
        $row = mysql_fetch_array($res);
        return 'Username:'.$row['username'];