<html> <head> <body> <form action="" method="post"> <input type="submit" /> </form> <?php //POLACZ $conn = mysql_connect('localhost','login','haslo'); if (!$conn ) { die('Błąd połczenia z serwerem: ' . mysql_error()); } mysql_select_db('baza'); //DODAJ DRUZYNE if(!empty($_POST['gosp'])) { echo "<p style='font-size: 10px'>ktory: <form action='' method='post'>"; for($i=0;$i<$_POST['br_gosp'];$i++) { $a = "SELECT count(*) FROM kopacze WHERE team_id = ".$_POST['gosp'].";"; $b = mysql_query("SELECT * FROM kopacze WHERE team_id = ".$_POST['gosp'].";"); echo "<select name='gool".$i."'>"; $k = mysql_fetch_array(mysql_query($a)); for($nrk=1;$nrk<=$k[0];$nrk++) { $row = mysql_fetch_array($b); echo "<option value='".$row[0]."'>".$row[1]." ".$row[2]."</option>"; } echo "</select>"; } for($i=0;$i<$_POST['br_gosp'];$i++) { $b = mysql_query("SELECT * FROM kopacze WHERE gracz_id = ".$_POST['gool'.$i].";"); $row = mysql_fetch_array($b); echo $row[0]." ".$row[1]." ".$row[2]." ".$row[3]." ".$row[4]." ".$row[5]." ".$row[6]."<br>"; $row[6] = $row[6] + 1; echo $row[6]."<br>"; mysql_query("UPDATE kopacze SET br_strzel=".$row[6]." WHERE gracz_id = ".$_POST['gool'.$i].";"); } } ?> </body> </head> </html>
teraz lepiej? wyskakuje błąd w linijce #35:
$row = mysql_fetch_array($b);