[PHP]Pusta tabela Opcje

[Nimlot20]

Mecze sie z pewnym skryptem i nie za bardzo wiem jak moznaby sprawdzic czy dana tabela jest pusta. Chodzi mi o tabele killers w bazie xyz

[PHP] pobierz, plaintext 
<?php
$main_content .= '<div style="text-align: center; font-weight: bold;">Top 30 frags on ' . $config['server']['serverName'] . '</div>
<table border="0" cellspacing="1" cellpadding="4" width="100%">
	<tr bgcolor="' . $config['site']['vdarkborder'] . '">
		<td class="white" style="text-align: center; font-weight: bold;">Name</td>
		<td class="white" style="text-align: center; font-weight: bold;">Frags</td>
	</tr>';
 
$i = 0;
foreach($SQL->query('SELECT `p`.`name` AS `name`, COUNT(`p`.`name`) as `frags`
	FROM `killers` k
	LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id`
	LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id`
WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1
	GROUP BY `name`
	ORDER BY `frags` DESC, `name` ASC
	LIMIT 0,30;') as $player)
{
	$i++;
	$main_content .= '<tr bgcolor="' . (is_int($i / 2) ? $config['site']['lightborder'] : $config['site']['darkborder']) . '">
		<td><a href="?subtopic=characters&name=' . urlencode($player['name']) . '">' . $player['name'] . '</a></td>
		<td style="text-align: center;">' . $player['frags'] . '</td>
	</tr>';
}
 
$main_content .= '</table>';
 
$zapytanie = $SQL->query('SELECT id, xyz FROM `killers` WHERE id IS NULL;') //sprawdzanie czy tabela jest pusta
 
if (!mysql_num_rows($zapytanie))
	$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><B>Top 30 frags on ' . $config['server']['serverName'] . '</B></TD></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1><TR><TD>Currently nobody has one or more frags.</TD></TR></TABLE></TD></TR></TABLE><BR>';
 
?>
[PHP] pobierz, plaintext 

Ten post edytował Nimlot20 12.03.2010, 18:19:32

[erix]

A nie prościej przed pętlą dać coś takiego?

[PHP] pobierz, plaintext 
$isEmpty = true;
foreach(){
 
# ...
 
$isEmpty = false;
}
 
if($isEmpty){
# pusto tu jak u kościelnego w kieszeni
}
[PHP] pobierz, plaintext