[thomasubc]

I added the table Link and now am recieving the error

Query:

INSERT INTO partsx(`Description`, `Part_Number`, `Document', `Link`) VALUES('SAS Type I','a','b', 'c')

Failed with 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 'Link`) VALUES('SAS Type I','a','b', 'c')' at line 1.

I do not see the problem.


Code is below

<?php
include 'inputdata.php';
//connecting to databse;
if (!mysql_connect('localhost:3306', $username, $password)) {
   die('Failed to connect to database');
}
if (!mysql_select_db($database)) {
    die("Failed to select database $database". mysql_error());
}
//
//collecting data from index.php;
$Description = mysql_real_escape_string($_POST["Description"]);
$Part_Number = $_POST["Part_Number"];
$Document = mysql_real_escape_string($_POST["Document"]);
$Link = mysql_real_escape_string($_POST["Link"]);
//inserting data into table partsx;
$create = "INSERT INTO partsx(`Description`, `Part_Number`, `Document', `Link`) VALUES('$Description','$Part_Number','$Document', '$Link')";
mysql_query($create) or die("Query $create failed: " .mysql_error());
?>

This post has been edited by RudiVisser: 08 September 2011 - 12:26 PM
Reason for edit:: use [CODE] tags (correctly)!

[RudiVisser]

Ah the good old simple-but-annoying errors

You have an apostrophe instead of a backtick, right here: `Document', `Link`.

EDIT: Happy 3000th post to me!

This post has been edited by RudiVisser: 08 September 2011 - 12:47 PM

[lrk89]

I have basic php and mysql experience as im still learning but shouldn't you try sending information to the database after you make the query and declare it to a variable? Code line 16 looks like it should come after... shoot me if i'm wrong and explain why :-)

[thomasubc]

I can see where you were mislead. The "//" means that the following line is a comment. I find it useful because I can get lost in writing code and forget what things mean. I pass it on you. Let me know if you find it helpful.

[RudiVisser]

thomasubc, on 08 September 2011 - 08:44 PM, said:

I can see where you were mislead. The "//" means that the following line is a comment. I find it useful because I can get lost in writing code and forget what things mean. I pass it on you. Let me know if you find it helpful.

Did you resolve your problem by fixing the quote?

[thomasubc]

Thank you, it took some searching but I found it. I thought they were the same key. Thank you for setting me straight!

RudiVisser, on 08 September 2011 - 12:26 PM, said:

Ah the good old simple-but-annoying errors

You have an apostrophe instead of a backtick, right here: `Document', `Link`.

EDIT: Happy 3000th post to me!

That fixed the problem!