[PHP]ShoutBox, mysql_fetch_row(): supplied argument is not a valid MySQL result ... Opcje

[blacki]

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\usr\krasnal\www\nowy folder\get_data.php on line 7

oto linia 7:

[PHP] pobierz, plaintext 
 while($r = mysql_fetch_row($q)){
[PHP] pobierz, plaintext 

gdzie jest tu błąd?

[piotrooo89]

nie ty tylko w mysql_query. zastosuje mysql_error() do sprawdzenia błędu.

[blacki]

Nie do końca rozumiem, oto cały kod:

[PHP] pobierz, plaintext 
<?php
include("config.php");
$db = @mysql_connect($sql_serwer,$sql_user,$sql_pass);
 @mysql_select_db($sql_baza);
 
 $q = mysql_query("SELECT * FROM `shoutbox` ORDER BY `data` DESC LIMIT $iloscWpisow");
 while($r = mysql_fetch_row($q)){
  ?>
 <div id="wpis">
 <strong>Nick: </strong><?php echo $r[1];?><br />
 <p class="tresc"><?php echo $r[2];?></p>
 <hr noshade="noshade" size="1" width="90%" />
 <p class="data"><?php echo $r[3];?></p>
 </div>
  <?php
 }
?>
[PHP] pobierz, plaintext 

Co powinienem zmienić?

[piotrooo89]

[PHP] pobierz, plaintext 
include("config.php");
$db = mysql_connect($sql_serwer,$sql_user,$sql_pass);
mysql_select_db($sql_baza);
 
$q = mysql_query("SELECT * FROM `shoutbox` ORDER BY `data` DESC LIMIT $iloscWpisow") or die(mysql_error());
while($r = mysql_fetch_row($q))
{
echo '<div id="wpis">
		<strong>Nick: </strong>'.$r[1].'<br />
		<p class="tresc">'.$r[2].'</p>
		<hr noshade="noshade" size="1" width="90%" />
		<p class="data">'.$r[3].'</p>
	</div>;'
}
[PHP] pobierz, plaintext 

co się dzieje?

[blacki]

Parse error: parse error, expecting `','' or `';'' in c:\usr\krasnal\www\nowy folder\get_data.php on line 15

[Blame]

[PHP] pobierz, plaintext 
include("config.php");
$db = mysql_connect($sql_serwer,$sql_user,$sql_pass);
mysql_select_db($sql_baza);
 
$q = mysql_query("SELECT * FROM `shoutbox` ORDER BY `data` DESC LIMIT $iloscWpisow") or die(mysql_error());
while($r = mysql_fetch_row($q))
{
echo '<div id="wpis">
		<strong>Nick: </strong>'.$r[1].'<br />
		<p class="tresc">'.$r[2].'</p>
		<hr noshade="noshade" size="1" width="90%" />
		<p class="data">'.$r[3].'</p>
	</div>';
}
[PHP] pobierz, plaintext 

Teraz spróbuj.

[blacki]

Okej teraz sprawne... musze jeszcze baze danych podstawić... dzięki