SQL-Abfrage LIKE

[Christian]

zeig doch mal die sql abfragen der beiden unteren tabellen, damit wir den aktuellen rausbekommen.

ok, danke für deine hilfe

anbei die abfrage der now-playing list

$user = mysql_query("select uid, uname, user_aim, user_yim, user_msnm FROM nuke_users WHERE user_aim LIKE '%$Author%' OR user_yim LIKE '%$Author%' OR user_msnm LIKE '%$Author%' ORDER BY RAND(),uid LIMIT 3");
//$array2 = mysql_fetch_array($user);
while($array2 = mysql_fetch_assoc($user)) {

$array2[user_aim] = stripslashes($array2[user_aim]);
$array2[user_aim] = ucwords ($array2[user_aim]);
$array2[user_aim] = str_replace("1.","",$array2[user_aim]);
$array2[user_aim] = str_replace("/","",$array2[user_aim]);

$array2[user_yim] = stripslashes($array2[user_yim]);
$array2[user_yim] = ucwords ($array2[user_yim]);
$array2[user_yim] = str_replace("2.","",$array2[user_yim]);
$array2[user_yim] = str_replace("/","",$array2[user_yim]);

$array2[user_msns] = stripslashes($array2[user_msnm]);
$array2[user_msnm] = ucwords ($array2[user_msnm]);
$array2[user_msnm] = str_replace("3.","",$array2[user_msnm]);
$array2[user_msnm] = str_replace("/","",$array2[user_msnm]);

echo "<table>";
echo "<tr><td>$array2[user_aim] <a class="linkrot" href="">>></a><td></tr>";
echo "<tr><td>$array2[user_yim] <a class="linkrot" href="">>></a></td></tr>";
echo "<tr><td>$array2[user_msnm] <a class="linkrot" href="">>></a></td></tr>";
echo "</table>";