将电子邮件地址插入表格字段 [英] Inserting an email address into a table field

问题描述

// write student record
$query = "INSERT INTO Student (SLastName, SFirstName, SeMail, SGrade, SPhone, SCell, SLunch)".
" VALUES ($LastName, $FirstName, $email, $grade, $phone, $cell, $lunch)";
echo $query . '<br />';
$result = mysql_query($query);
if (!$result)
     die("Error inserting Student record: ". mysql_error());

---

INSERT INTO Student (SLastName, SFirstName, SeMail, SGrade, SPhone, SCell, SLunch)
VALUES (Weiner, Wendy, [e-mail], 12, 2123334444, 8458765555, 5)

---

错误:您的SQL语法有错误；在第1行的'@ gmail.com，12，2123334444，8458765555，5)'附近检查与MySQL服务器版本相对应的手册以使用正确的语法

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@gmail.com, 12, 2123334444, 8458765555, 5)' at line 1

服务器版本:5.0.91-community

Server version: 5.0.91-community

推荐答案

那不是

INSERT INTO Student (SLastName, SFirstName, SeMail, SGrade, SPhone, SCell, SLunch)
VALUES (Weiner, Wendy, '[e-mail]', 12, 2123334444, 8458765555, 5)

i.e.带有引号的电子邮件地址?

i. e. with the email address in quotes?

这篇关于将电子邮件地址插入表格字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！