Hello,
I would like to INSERT the following string into the sql statement, $ProjTimeSQL["Sun"][1], but it gives me an error. I presume it is because of the "Sun", if I do Sun it works obviously. How do I go abouts including the "" in the sql statement?
Hello again,
I forgot: You can do this only with MySQL.
Perhaps other SQL-servers allow this, too.
Dave
Well if you want it to appear as it is shown ($ProjTimeSQL["Sun"][1]) then it should work if you escape the quotes and probably the $ as well, with a \
so it would look like:
\$ProjTimeSQL[\"Sun\"][1]
The $ is what you may have trouble with.
Ehm.. ok.. and why is that?
You don't, instead, you take the $Projthing out of the quotes:
$sql_ query="INSERT INTO table (field) VALUES (".$ProjTimeSQL['Sun'][1].")";
So the $ Proj is concatenated into the string.
