[MySQL][PHP] Wyświetlanie wyników w tabeli. Opcje

[DDK15]

Witam, mam problem gdyż stworzyłem prosty skrypt do pobierania danych z mysql i wyświetlania ich w tabeli. Wszystko działa pięknie, jeżeli coś w tej tabeli jest, ale jak nie ma to pojawiają się błędy. Proszę o pomoc

Kod

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 6 in reward_history.php on line 12

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 7 in reward_history.php on line 13

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 8 in reward_history.php on line 14

[PHP] pobierz, plaintext 
<?php
$usernameb = $_SESSION['username'];
$query1 = "SELECT username FROM history ORDER BY id";  
$result1 = mysql_query($query1) or die(mysql_error()); 
$query2 = "SELECT reward FROM history WHERE username='$usernameb' ORDER BY id";  
$result2 = mysql_query($query2) or die(mysql_error()); 
$query3 = "SELECT date FROM history WHERE username='$usernameb' ORDER BY date DESC"; 
$result3 = mysql_query($query3) or die(mysql_error());
$query4 = "SELECT status FROM history WHERE username='$usernameb' ORDER BY id";   
$result4 = mysql_query($query4) or die(mysql_error());
$username =  mysql_result($result1,$usernameb);
$reward = mysql_result($result2,"reward");
$date = mysql_result($result3,"date");
$status = mysql_result($result4,"status");
$num=mysql_num_rows($result3);
?>
 
       <table border="1" cellpadding="10">
		<tr><td><strong>Username</strong></td><td><strong>Reward</strong></td><td><strong>Date</strong></td><td><strong>Status</strong></td></tr>
<?php
$i=0;
if($num>0){
while ($i < $num) {
$reward=mysql_result($result2,$i,"reward");
$date=mysql_result($result3,$i,"date");
$status=mysql_result($result4,$i,"status");
$i++;
 
echo"<tr><td>".$usernameb."</td><td>".$reward."</td><td>".$date."</td><td>".$status."</td></tr>";
}
}
else { echo "No elements to display"; }
?>
	</table>
[PHP] pobierz, plaintext 

Ten post edytował DDK15 18.06.2012, 09:56:02