PHP 出现这个错误：undefined index

Question

<?php
header("Content-Type: text/html;charset=utf-8");
$url = "localhost";
$user = "root";
$password = "";
$scenicArray = array();
$i = 0;
$con = mysql_connect($url,$user,$password);
if (!$con){
die('Could not connect: ' . mysql_error());
}
mysql_query("set names 'utf8'");
mysql_select_db("smart_tour");
$query = "select Scenic_Id,Scenic_Name,Scenic_city,Scenic_photo from `scenic`";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
$scenicArray[$i]['Secenic_Id']=$row['Secenic_Id'];
$scenicArray[$i]['Scenic_Name'] = $row['Scenic_Name'];
$scenicArray[$i]['Scenic_city'] = $row['Scenic_city'];
$scenicArray[$i]['Scenic_photo'] = $row['Scenic_photo'];
$i++;
}
mysql_close($con);
$scenicJson= json_encode($scenicArray);
echo $scenicJson;
?>

Notice: Undefined index: Secenic_Id in D:\wamp\www\sceniclist.php on line 17

Answer 1

17行是这个吧：
$scenicArray[$i]['Secenic_Id']=$row['Secenic_Id'];

Undefined index错误的程序里面的数组下标不存在，你这里$row['Secenic_Id']错，没有下标'Secenic_Id'，因为你的查询语句是“$query = "select Scenic_Id”，查询的第一个字段是Sc，你使用的是Sec，有区别。追问

啊啊啊，我简直太不认真了！谢谢啦！

追答

早知道你这么清醒我都不同打那么多字了。

Answer 2

$result = mysql_query($query,$con);第17行试试