little error

[sepultura]

when i run the following script

<?php
mysql_pconnect ("...", "...", "...");

mysql_select_db ("...");
$qResult = mysql_query ("SELECT * FROM news ORDER BY id DESC");

$nRows = mysql_num_rows($qResult);
$rString ="&n=".$nRows;

for ($i=0; $i< $nRows; $i++){
$row = mysql_fetch_array($qResult);
$rString .="&update".$i."=".$row['update']."&";
}
echo $rString."&";

?>

this error appears
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.../public_html/news.php on line 7
&n=

i am trying to load my table into flash. it's more of a headache than it should be. thank you anyone who can help.

[YappyDog]

Looks like it is trying to tell you your query did not return any results into your $qResult variable.

[wilsonodk]

Check to make sure it's returning rows before you continue.

<?php
mysql_pconnect ("...", "...", "...");
mysql_select_db ("...");

$qResult = mysql_query ("SELECT * FROM news ORDER BY id DESC") or die(mysql_error());

if (mysql_num_rows($qResult)>0) {
  $nRows = mysql_num_rows($qResult);
  $rString ="&n=".$nRows;

  for ($i=0; $i< $nRows; $i++){
    $row = mysql_fetch_array($qResult);
    $rString .= "&update".$i."=".$row['update']."&";
  }

  echo $rString."&";

} else {
  echo "No entries in database found.";
}
?>

Also, do you need two ampersands ('&') in your output?
[font=courier]$rString .= "&update".$i."=".$row['update']."&";[/font]