Обучение/Помощь новичкам | kak исправить?
E-Vine
echo"<table class='post'>";
echo"<td class='p_t'>";
echo "<small>Награды/<a href=\"rank.php?id=$ank[id]\" title=\"Все\">Награды</a></small>\n";
$k_p=mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = $ank[id] ",$db), 0);
echo " ($k_p)<br />";
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = '$ank[id]' LIMIT 1", 0);
if ($k_post==0)
{
echo '<sub> Oбитатель '.$ank['nick'].' не награждался</sub>';
}
$q = mysql_query("SELECT * FROM `rank` WHERE `id_user` = '$ank[id]' ORDER BY time DESC LIMIT 4";
while ($f = mysql_fetch_array($q))
{
$a = mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$f[ot_id]' LIMIT 1");
echo"<img src='/rank/".$f['id_rank'].".gif' width='20' height='20' alt='' class='icon'/></hr>";
}
echo' </td>
</tr>
</table>';
________
посл. ред. 14.03.2015 в 20:28; всего 1 раз(а); by 155045003
echo"<td class='p_t'>";
echo "<small>Награды/<a href=\"rank.php?id=$ank[id]\" title=\"Все\">Награды</a></small>\n";
$k_p=mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = $ank[id] ",$db), 0);
echo " ($k_p)<br />";
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = '$ank[id]' LIMIT 1", 0);
if ($k_post==0)
{
echo '<sub> Oбитатель '.$ank['nick'].' не награждался</sub>';
}
$q = mysql_query("SELECT * FROM `rank` WHERE `id_user` = '$ank[id]' ORDER BY time DESC LIMIT 4";
while ($f = mysql_fetch_array($q))
{
$a = mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$f[ot_id]' LIMIT 1");
echo"<img src='/rank/".$f['id_rank'].".gif' width='20' height='20' alt='' class='icon'/></hr>";
}
echo' </td>
</tr>
</table>';
________
посл. ред. 14.03.2015 в 20:28; всего 1 раз(а); by 155045003
$k_p=mysql_result(mysql_query("SELECT COUNT(*)
FROM `rank` WHERE `id_user` = '".$ank['id']."'",$db), 0);
TheAlex FROM `rank` WHERE `id_user` = '".$ank['id']."'",$db), 0);
Саня (14.03.2015 в 09:54)
$k_p=mysql_result(mysql_query("SELECT COUNT(*)
FROM `rank` WHERE `id_user` = '".$ank['id']."'",$db), 0);
$k_p=mysql_result(mysql_query("SELECT COUNT(*)
FROM `rank` WHERE `id_user` = '".$ank['id']."'",$db), 0);
Всеравно
155045003 , не там ошибка значит
echo"<table class='post'>";
echo"<td class='p_t'>";
echo "<small>Награды/<a href=\"rank.php?id=$ank[id]\" title=\"Все\">Награды</a></small>\n";
$k_p=mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = $ank[id] ",$db), 0);
echo " ($k_p)<br />";
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = '$ank[id]' LIMIT 1"), 0);
if ($k_post==0)
{
echo '<sub> Oбитатель '.$ank['nick'].' не награждался</sub>';
}
$q = mysql_query("SELECT * FROM `rank` WHERE `id_user` = '$ank[id]' ORDER BY time DESC LIMIT 4");
while ($f = mysql_fetch_array($q))
{
$a = mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$f[ot_id]' LIMIT 1"));
echo"<img src='/rank/".$f['id_rank'].".gif' width='20' height='20' alt='' class='icon'/></hr>";
}
echo' </td>
</tr>
</table>';
Повний код
echo"<td class='p_t'>";
echo "<small>Награды/<a href=\"rank.php?id=$ank[id]\" title=\"Все\">Награды</a></small>\n";
$k_p=mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = $ank[id] ",$db), 0);
echo " ($k_p)<br />";
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = '$ank[id]' LIMIT 1"), 0);
if ($k_post==0)
{
echo '<sub> Oбитатель '.$ank['nick'].' не награждался</sub>';
}
$q = mysql_query("SELECT * FROM `rank` WHERE `id_user` = '$ank[id]' ORDER BY time DESC LIMIT 4");
while ($f = mysql_fetch_array($q))
{
$a = mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$f[ot_id]' LIMIT 1"));
echo"<img src='/rank/".$f['id_rank'].".gif' width='20' height='20' alt='' class='icon'/></hr>";
}
echo' </td>
</tr>
</table>';
Повний код
155045003 (14.03.2015 в 10:11)
echo"<table class='post'>";
echo"<td class='p_t'>";
echo "<small>Награды/<a href="rank.php?id=$ank[id]" title="Все">Награды</a></small>n";
$k_p=mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = $ank[id] ",$db), 0);
echo " ($k_p)<br />";
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = '$ank[id]' LIMIT 1"), 0);
if ($k_post==0)
{
echo '<sub> Oбитатель '.$ank['nick'].' не награждался</sub>';
}
$q = mysql_query("SELECT * FROM `rank` WHERE `id_user` = '$ank[id]' ORDER BY time DESC LIMIT 4");
while ($f = mysql_fetch_array($q))
{
$a = mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$f[ot_id]' LIMIT 1"));
echo"<img src='/rank/".$f['id_rank'].".gif' width='20' height='20' alt='' class='icon'/></hr>";
}
echo' </td>
</tr>
</table>';
Повний код
echo"<table class='post'>";
echo"<td class='p_t'>";
echo "<small>Награды/<a href="rank.php?id=$ank[id]" title="Все">Награды</a></small>n";
$k_p=mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = $ank[id] ",$db), 0);
echo " ($k_p)<br />";
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = '$ank[id]' LIMIT 1"), 0);
if ($k_post==0)
{
echo '<sub> Oбитатель '.$ank['nick'].' не награждался</sub>';
}
$q = mysql_query("SELECT * FROM `rank` WHERE `id_user` = '$ank[id]' ORDER BY time DESC LIMIT 4");
while ($f = mysql_fetch_array($q))
{
$a = mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$f[ot_id]' LIMIT 1"));
echo"<img src='/rank/".$f['id_rank'].".gif' width='20' height='20' alt='' class='icon'/></hr>";
}
echo' </td>
</tr>
</table>';
Повний код
говнокод.
155045003 ,
вот так попробуй
echo"<table class='post'>";
echo"<td class='p_t'>";
echo "<small>Награды/<a href=\"rank.php?id=$ank[id]\" title=\"Все\">Награды</a></small>\n";
$k_p=mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = $ank[id] ",$db), 0);
echo " ($k_p)<br />";
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = '$ank[id]' LIMIT 1";), 0);
if ($k_post==0)
{
echo '<sub> Oбитатель '.$ank['nick'].' не награждался</br>';
}
$q = mysql_query("SELECT * FROM `rank` WHERE `id_user` = '$ank[id]' ORDER BY time DESC LIMIT 4";);
while ($f = mysql_fetch_array($q))
{
$a = mysql_fetch_array(mysql_query("SELECT FROM `user` WHERE `id` = '$f[ot_id]' LIMIT 1");
echo"<img src='/rank/".$f['id_rank'].".gif' width='20' height='20' alt='' class='icon'/></hr>";
}
echo' </td>
</tr>
</table>';
EXCAVATOR вот так попробуй
echo"<table class='post'>";
echo"<td class='p_t'>";
echo "<small>Награды/<a href=\"rank.php?id=$ank[id]\" title=\"Все\">Награды</a></small>\n";
$k_p=mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = $ank[id] ",$db), 0);
echo " ($k_p)<br />";
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = '$ank[id]' LIMIT 1";), 0);
if ($k_post==0)
{
echo '<sub> Oбитатель '.$ank['nick'].' не награждался</br>';
}
$q = mysql_query("SELECT * FROM `rank` WHERE `id_user` = '$ank[id]' ORDER BY time DESC LIMIT 4";);
while ($f = mysql_fetch_array($q))
{
$a = mysql_fetch_array(mysql_query("SELECT FROM `user` WHERE `id` = '$f[ot_id]' LIMIT 1");
echo"<img src='/rank/".$f['id_rank'].".gif' width='20' height='20' alt='' class='icon'/></hr>";
}
echo' </td>
</tr>
</table>';
155045003 , А ошибку какую выдаёт? Или белый экран?
CreepMatis 
155045003 (14.03.2015 в 10:11)
echo"<table class='post'>";
echo"<td class='p_t'>";
echo "<small>Награды/<a href="rank.php?id=$ank[id]" title="Все">Награды</a></small>n";
$k_p=mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = $ank[id] ",$db), 0);
echo " ($k_p)<br />";
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = '$ank[id]' LIMIT 1"), 0);
if ($k_post==0)
{
echo '<sub> Oбитатель '.$ank['nick'].' не награждался</sub>';
}
$q = mysql_query("SELECT * FROM `rank` WHERE `id_user` = '$ank[id]' ORDER BY time DESC LIMIT 4");
while ($f = mysql_fetch_array($q))
{
$a = mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$f[ot_id]' LIMIT 1"));
echo"<img src='/rank/".$f['id_rank'].".gif' width='20' height='20' alt='' class='icon'/></hr>";
}
echo' </td>
</tr>
</table>';
Повний код
echo"<table class='post'>";
echo"<td class='p_t'>";
echo "<small>Награды/<a href="rank.php?id=$ank[id]" title="Все">Награды</a></small>n";
$k_p=mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = $ank[id] ",$db), 0);
echo " ($k_p)<br />";
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `rank` WHERE `id_user` = '$ank[id]' LIMIT 1"), 0);
if ($k_post==0)
{
echo '<sub> Oбитатель '.$ank['nick'].' не награждался</sub>';
}
$q = mysql_query("SELECT * FROM `rank` WHERE `id_user` = '$ank[id]' ORDER BY time DESC LIMIT 4");
while ($f = mysql_fetch_array($q))
{
$a = mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$f[ot_id]' LIMIT 1"));
echo"<img src='/rank/".$f['id_rank'].".gif' width='20' height='20' alt='' class='icon'/></hr>";
}
echo' </td>
</tr>
</table>';
Повний код
ошибка тут echo "<small>Награды/<a href="rank.php?id=$ank[id]" title="Все">Награды</a></small>n";
Синтаксис епа мама))
De Plain