Query error while inserting into Database

Question

I'm just trying to insert some variables into a DB. The connection works but I keep getting a query error.

Here's the HTML:

<form action="process-step1.php" method="post">

    <div id="fromDiv" class="clearfix">
        <h4>Your Name</h4>
        <input type="text" name="from" id="from" value="" />
        <h4>Your E-mail</h4>
        <input type="text" name="fromemail" id="fromemail" value="" />
    </div>

    <div id="toDiv" class="clearfix">
        <h4>Recipient Name</h4>
        <input type="text" name="to" id="to" value="" />
        <h4>Recipient E-mail</h4>
        <input type="text" name="toemail" id="toemail" value="" />
    </div>

    <div id="messageDiv" class="clearfix">
        <h4>Message</h4>
        <textarea name="message" id="message"></textarea>
    </div>

    <div id="submitDiv" class="clearfix">
        <input type="submit" value="Preview my Card" name="submit" id="submit" />
    </div>

</form>

Here is the PHP Process:

$from = mysql_escape_string($_POST['from']);
$fromemail = mysql_escape_string($_POST['fromemail']);
$to = mysql_escape_string($_POST['to']);
$toemail = mysql_escape_string($_POST['toemail']);
$message = mysql_escape_string($_POST['message']);

$query = "INSERT INTO cards (fromemail, from, to, toemail, message, stamp) VALUES ('$fromemail', '$from', '$to', '$toemail', '$message', 'now()' )";
$results = mysql_query($query);

Any help would be appreciated. Thanks in advance.

KV Prajapati · Accepted Answer · 2011-12-07 03:49:38Z

1

Escape the reserved word - To and From.

$query = "INSERT INTO cards (fromemail, `from`, `to`, toemail, message, stamp) VALUES 
           ('$fromemail', '$from', '$to', '$toemail', '$message', 'now()' )";

answered Dec 7, 2011 at 3:49

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Peter Over a year ago

Thank you for this answer. I have changed the field/variable names and it worked.

Rupesh Pawar · Accepted Answer · 2011-12-07 03:48:38Z

0

Try this

$query = "INSERT INTO cards (fromemail, from, to, toemail, message, stamp) VALUES ('".$fromemail."', '".$from."', '".$to."', '".$toemail."', '".$message."', '".now()' )";

answered Dec 7, 2011 at 3:48

Rupesh Pawar

1,9071 gold badge12 silver badges17 bronze badges

Collectives™ on Stack Overflow

Query error while inserting into Database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related