Error #1064

[DarkSinister]

Hi there!

I know there are many threads concerning #1064, but in none of them I found the information neccessary to solve my problem...

Ok, here is my code (just copied the neccessary lines):

function mysql_die($error = "unknown")
{
echo "<div style='color:red'>An error occured while proccesing your request. <br>";
echo "<font size=-1>Error type: <i>" . $error . "</i><br>";
echo "Error number / Error type (PhP Syntax): <i>" . mysql_errno() . ": " . mysql_error() . "</font></div><br><br>";
exit;
}

$sqlAct = $_GET['sqlAc'] . 'ID, Klasse, Typ, Qualit, Menge, Account, Char) VALUES (' . $_GET['id'] . ', ' . $_GET['cl']  . ', ' . $_GET['ty'] . ', ' . $_GET['ql'] .', ' . $_GET['qn'] . ', ' . $_GET['ac'] . ', ' . $_GET['ch'] . ')';
$verbindung = mysql_connect($server, $Benutzer, $Kennwort);
echo 'Verbindung: ' . $verbindung . '<br>';
$what = mysql_select_db($datab, $verbindung);
if($what > 0) echo "<i><font size=-2>Successfully connected to database: <u>" . $datab . "</u><br><br><br><br><br></i>";
else {
mysql_die("Unable to connect to database");
}
$ergebnis = mysql_query($sqlAct, $verbindung) or mysql_die("Not able to write into selected table");

And here is the result

An error occured while proccesing your request.
Error type: Not able to write into selected table
Error number / Error type (PhP Syntax): 1064: You have an error in your SQL syntax near 'Char) VALUES (3, xSpec23, acCable, Elite, 1, *georgeThe[Best], KoR_Device)' at line 1

I wasn't able to solve the problem
Is any1 able to help me please?

so long

[notionlogic]

From your example code, I assume that some of those fields are VARCHAR (or CHAR)? If so then the data will need double quotes (e.g. "data", "data" etc) won't it?

[DarkSinister]

yeah, right, some of them are VARCHAR...

so I tried what you told me to:

function mysql_die($error = "unknown")
{
echo "<div style='color:red'>An error occured while proccesing your request. <br>";
echo "<font size=-1>Error type: <i>" . $error . "</i><br>";
echo "Error number / Error type (PhP Syntax): <i>" . mysql_errno() . ": " . mysql_error() . "</font></div><br><br>";
exit;
}

$sqlAct = $_GET['sqlAc'] . '"ID", "Klasse", "Typ", "Qualit", "Menge", "Account", "Char") VALUES (' . '"' . $_GET['id'] . '"' . ', ' . '"' . $_GET['cl']  . '"' . ', ' . '"' . $_GET['ty'] . '"' . ', ' . '"' . $_GET['ql'] . '"' . ', ' . '"' . $_GET['qn'] . '"' . ', ' . '"' . $_GET['ac'] . '"' . ', ' . '"' . $_GET['ch'] . '"' . ')';
// '"' = ' " '
$verbindung = mysql_connect($server, $Benutzer, $Kennwort);
echo 'Verbindung: ' . $verbindung . '<br>';
$what = mysql_select_db($datab, $verbindung);
if($what > 0) echo "<i><font size=-2>Successfully connected to database: <u>" . $datab . "</u><br><br><br><br><br></i>";
else {
mysql_die("Unable to connect to database");
}
$ergebnis = mysql_query($sqlAct, $verbindung) or mysql_die("Not able to write into selected table");

Im still getting an error, the only thing that changed is a little bit different error message:

Error type: Not able to write into selected table
Error number: Error type (PhP Syntax): 1064: You have an error in your SQL syntax near '"ID", "Klasse", "Typ", "Qualit", "Menge", "Account", "Char") VALUES ("3", "xSp' at line 1

[notionlogic]

No, no, no... now there's too many double quotes 😃

You just need them around the VALUES not the COLUMN names

[DarkSinister]

An error occured while proccesing your request.
Error type: Not able to write into selected table
Error number: Error type (PhP Syntax): 1064: You have an error in your SQL syntax near 'Char) VALUES ("3", "xSpec23", "acCable", "Elite", "1", "*georgeThe[Best]", "KoR_Devic' at line 1

Helldamnit 🙁