Problem with Insert with ODBC
| From: | Veselina Jecheva | Date: | Mon, 30 Jun 2003 13:19:12 +0000 |
| Subject: | Problem with Insert with ODBC | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-20626@lists.php.net to get a copy of this message | ||
Hello,
I've got the following problem: the following line prints "Error" all the
time:
$link = odbc_connect("conference","","");
$query="insert into participants (name, surname, family, degree,
work_place, speaker, listener, topic, title,
co_author, aspekt, comp, proektor, video, date15, date16, date17,
fee)
values ('$name', '$surname', '$family', '$degree',
'$work_place',
'$speaker', '$listener', '$topic', '$title',
'$co_author', '$asp', '$computer', '$proekt',
'$video', '$date15',
'$date16', '$date17', '$fee')";
$result=odbc_exec($link,$query);
if ($result) echo "Thank you, your request has been processed.";
else echo "Error";
The database is created by Access, all variables are defined and have their
values. It seems the SQL statement is not ok.
Thank's in advance.
Veselina