php - 如何将多个复选框答案插入数据库表中？

Question

我在使用这个数据库时遇到了一个大问题。它与表单 $_POST 查询中的信息正确连接，这些信息被插入到表 company_info 的正确字段中。

现在，我不知道我在这里做错了什么，但我不断收到

的模具错误

"Error querying database".

数据库版本为:phpMyAdmin 2.6.4-pl3

MySQL:5.0

有什么想法吗？如果需要，我可以为您提供其余的代码。

$dbc = mysql_connect('db390590179.db.1and1.com', 'dbo390590179', '*********')
or die('Error connecting to MySQL server.');

mysql_select_db("db390590179", $dbc);


$query = "INSERT INTO company_info (company_name, company_phone,  company_contact, company_address, " .
"company_city, company_state, company_zip, " .
"state_living, vehicles, position, " .
"experience, training, hazmat, " .
"require_hazmat, load_nyc, take_truck_home, " .
"have_rider, have_pet, choose_route, " .
"fuel, cash_advance, days_before_home, " .
"log_system, slip_seat, pre_pass, " .
"ez_pass, health_insurance, retirement_plan, " .
"payment_plan, calculate_pay, freight, " .
"loads, home_on_time, idle_time, " .
"equipment_condition, canada)" .

"VALUES ('$company_name', $company_phone', '$company_contact', '$company_address', '$company_city', " .
"'$company_state', '$company_zip', " .
"'$state_living', '$vehicles', '$position', " .
"'$experience', '$training', '$hazmat', " .
"'$require_hazmat', '$load_nyc', '$take_truck_home', " .
"'$have_rider', '$have_pet', '$choose_route', " .
"'$fuel', '$cash_advance', '$days_before_home', " .
"'$log_system', '$slip_seat', '$pre_pass', " .
"'$ez_pass', '$health_insurance', '$retirement_plan', " .
"'$payment_plan', '$calculate_pay', '$freight', " .
"'$loads', '$home_on_time', '$idle_time', " .
"'$equipment_condition', '$canada')";

$result = mysql_query($query, $dbc)
or die('Error querying database.');

mysql_close($dbc);

Answer 1

我认为这是因为 INSERT 语句中变量 $company_phone 之前缺少引号。