Kod
$result = dbquery("SELECT * FROM fusion_hotlink");
$result2 = dbquery("SELECT * FROM fusion_users");
if (dbrows($result) && dbrows($result2))
{
while ($data = dbarray($result))
{
$id = $data['id'];
$ip = $data['ip'];
$referer = $data['referer'];
$dat = $data['datetime'];
$counter = 0;
echo "<tr>";
while ($data2 = dbarray($result2))
{
if ($ip = $data2['user_ip'])
{
echo "<td class='tbl2'>" . $data2['user_name'] . "</td>";
$counter = 1;
Break;
}
}
if ($counter = 0) {
echo "<td class='tbl2'>Nie odnaleziono</td>";
}
echo "<td class='tbl2'>$ip</td><td class='tbl2'>$referer</td><td class='tbl2'>$dat</td></tr>";
}
}
$result2 = dbquery("SELECT * FROM fusion_users");
if (dbrows($result) && dbrows($result2))
{
while ($data = dbarray($result))
{
$id = $data['id'];
$ip = $data['ip'];
$referer = $data['referer'];
$dat = $data['datetime'];
$counter = 0;
echo "<tr>";
while ($data2 = dbarray($result2))
{
if ($ip = $data2['user_ip'])
{
echo "<td class='tbl2'>" . $data2['user_name'] . "</td>";
$counter = 1;
Break;
}
}
if ($counter = 0) {
echo "<td class='tbl2'>Nie odnaleziono</td>";
}
echo "<td class='tbl2'>$ip</td><td class='tbl2'>$referer</td><td class='tbl2'>$dat</td></tr>";
}
}
I mam jeszcze jedną prośbę: gdyby ktoś mi podpowiedział jak zoptymalizować ten kod.