MySQL将更新参数视为一列
|
我有一个包含以下代码的PHP脚本:
$sql = \"UPDATE tbl_p2e_place
SET
`listingName` = $listing_name, `listingDescription` = $listing_description,
`listingSpecialOffers` = $listing_special_offers, `listingFoodTypes` = $listing_food_types,
`listingAddress` = $listing_address, `CityID` = $listing_city,
`listingGPSSouth` = $gps_coordinate_south, `listingGPSEast` = $gps_coordinate_east,
`listingLatitude` = $map_latitude, `listingLongitude` = $map_longitude,
`listingTime` = $listing_timing, `listingNumber` = $booking_number,
`listingEmail` = $email_address, `listingWebsite` = $lisiting_website,
`listingTwitter` = $lisiting_twitter, `listingFacebook` = $lisiting_facebook,
`listingIsFeatured` = $is_featured, `listingDisplay` = $display
WHERE listingID = $listing_id\";
if(!mysql_query($sql))
{
die(\'Update Error: \' . mysql_error());
}
mysql_close($con);
当我想运行查询时,出现以下错误:
Update Error: Unknown column \'Shop\' in \'field list\'
输入商店作为来自表单的输入。
是什么原因引起的,我该如何制止?
问候
没有找到相关结果
已邀请:
3 个回复
浩挎
师埠女
疾桓
当然,MySQL Server会告诉您没有名为\'some \'的列,并且您缺少逗号,而实际上您缺少该值前后的撇号。