strange error help
Posted: Mon Jul 11, 2005 5:16 pm
insertError: [2 at line 46] sqlite_query() [function.sqlite-query]: unrecognized token: ":"
Error in query SQL logic error or missing database
this is my insert.php
Error in query SQL logic error or missing database
this is my insert.php
Code: Select all
<?php
function errHandler($errno, $errstr, $errfile, $errline) {
echo "Error: <b>[$errno at line $errline] $errstr</b><br />\n";
}
set_error_handler("errHandler");
$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query = "";
if (isset($_POST['tableName'])){
$table = sqlite_escape_string($_POST['tableName']);
echo "insert";
if (!empty($_POST['title'])
&& !empty($_POST['info_dk'])
&& !empty($_POST['info_uk'])
&& !empty($_POST['land'])
&& !empty($_POST['vol'])
&& !empty($_POST['size'])
&& !empty($_POST['price'])) {
$id = md5(mktime());
$title = sqlite_escape_string($_POST['title']);
$info_dk = sqlite_escape_string($_POST['info_dk']);
$info_uk = sqlite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_string($_POST['size']);
$price = sqlite_escape_string($_POST['price']);
$query = "insert into $table (item_id, title, info_dk, info_uk, land, vol, size,price) values (
'$id',
'$title',
'$info_dk',
'$info_uk',
'$land',
'$vol',
'$size',
'$price')";
line 46 $result=sqlite_query($handle, $query) or die("Error in query ".sqlite_error_string(sqlite_last_error($handle)));
}
echo "Record added.";
}
echo "Returning to main.";
header ("Location: ../index2.php");
exit;
?>
i can't find the ":" in line 46 - how can i solve this?