php - undefined offset : 0 error

Question

我的代码出现此错误

Notice: Undefined offset: 0 in C:\xampp\htdocs\rekmovie\paginator.php on line 29

这是完整的代码

<?php 
$con=mysql_connect("localhost","root","");
$conn=mysql_select_db('rektechnologies'); 
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  } // include your code to connect to DB.
if (!empty($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }; 
$start_from = ($page-1) * 20; 
$sql = "select * from videos order by id desc LIMIT $start_from, 10";
$rs_result = mysql_query($sql,$con); 
?> 
<table>
<tr><td>Name</td><td>Phone</td></tr>
<?php 
while ($row = mysql_fetch_assoc($rs_result)) { 
?> 
            <tr>
            <td><? echo $row["path"]; ?></td>
            <td><? echo $row["description"]; ?></td>
            </tr>
<?php 
}; 
?>
<?php 
$sql = "SELECT COUNT(*) FROM videos"; 
$rs_result = mysql_query($sql,$con); 
$row = mysql_fetch_assoc($rs_result); 
$total_records = $row[0];
$total_pages = ceil($total_records / 10);
for ($i=1; $i<=$total_pages; $i++) { 
    echo "<a href='paginator.php?page=".$i."'>".$i."</a> "; 
}; 
?>
</table>

谁能帮我解决这个错误

Answer 1

改变

$row = mysql_fetch_assoc($rs_result); 

至:

$row = mysql_fetch_row($rs_result);

mysql_fetch_assoc 返回一个关联数组，但您正在尝试访问 $row[0]，它需要一个索引数组。