HELP! sqlite update problem[solved]

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
nexus6
Forum Newbie
Posts: 20
Joined: Fri Jun 17, 2005 3:50 am
Location: Denmark

HELP! sqlite update problem[solved]

Post by nexus6 »

I get this error:
UpdateError: [2 at line 61] sqlite_query() [function.sqlite-query]: near "ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = "UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id";

(line 61)              $result = sqlite_query($handle, $query) or die("Error in query:      ".sqlite_error_string(sqlite_last_error($handle)));
		}
}
where can the error be? i cant find it...POST['info_dk'])
&& !empty($_POSTї'info_uk'])
&& !empty($_POSTї'land'])
&& !empty($_POSTї'vol'])
&& !empty($_POSTї'size'])
&& !empty($_POSTї'price'])) {


$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 = &quote;UPDATE $table SET
title='$title',
info_dk='$info_dk',
info_uk='$info_uk',
land='$land',
vol='$vol',
size='$size',
price='$price'
WHERE item_id=$id&quote;;

(line 61) $result = sqlite_query($handle, $query) or die(&quote;Error in query: &quote;.sqlite_error_string(sqlite_last_error($handle)));
}
}

where can the error be? i cant find it...k='$info_uk',
land='$land',
vol='$vol',
size='$size',
price='$price'
WHERE item_id=$id";

(line 61) $result = sqlite_query($handle, $query) or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
}
}

where can the error be? i cant find it... query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = "UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id";

(line 61)              $result = sqlite_query($handle, $query) or die("Error in query:      ".sqlite_error_string(sqlite_last_error($handle)));
		}
}
where can the eamp;& !empty($_POST['info_dk'])
&& !empty($_POST['info_uk'])
&& !empty($_POST['land'])
&& !empty($_POST['vol'])
&& !empty($_POST['size'])
&& !empty($_POST['price'])) {


$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 = &quote;UPDATE $table SET
title='$title',
info_dk='$info_dk',
info_uk='$info_uk',
land='$land',
vol='$vol',
size='$siST['info_uk'])
&& !empty($_POST['land'])
&& !empty($_POST['vol'])
&& !empty($_POST['size'])
&& !empty($_POST['price'])) {


$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'])nction.sqlite-query]: near "ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POSTї'title'])
   && !empty($_POSTї'info_dk'])
   && !empty($_POSTї'info_uk'])
   && !empty($_POSTї'land'])
   && !empty($_POSTї'vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='
[quote]
UpdateError: [2 at line 61] sqlite_query() [function.sqlite-query]: near "ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = &7": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo &quote;Update&quote;;
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POSTї'land'])
   && !empty($_POSTї'vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
             ]

my code:

Code: Select all

echo &quote;Update&quote;;
	
   if (!empty($_POSTї'title'])
   && !empty($_POSTї'info_dk'])
   && !empty($_POSTї'info_uk'])
   && !empty($_POSTї'land'])
   && !empty($_POSTї'vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id&quote;;

(line 61)           e6350537": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo &quote;Update&quote;;
	
   if (!empty($_POSTї'title'])
   && !empty($_POSTї'info_dk'])
   && !empty($_POSTї'info_uk'])
   && !empty($_POSTї'land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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']);
537": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id&quote;;

(line 61)              $result = sqlite_query($handle, $query) or die(&quote;Error in query: !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = "UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id";

(line 61)              $result = sqlite_query($handle, $query) or die("Error in query:      ".sqlite_error_string(sqlite_last_error($handle)));
		}
}
where can the error be? i cant find it...pty($_POST['vol'])
&& !empty($_POST['size'])
&& !empty($_POST['price'])) {


$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 = &quote;UPDATE $table SET
title='$title',
info_dk='$info_dk',
info_uk='$info_uk',
land='$land',
vol='$vol',
size='$size',
price='$price'
WHERE item_id=$id";

(line 61) $result = sqlite_query($handle, $query) or die("Error in query: ".sqlite_error_str"ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POSTї'size'])
   && !empty($_POST['price'])) {


			$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 61] sqlite_query() [function.sqlite-query]: near "ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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($_ logic error or missing database
[/quote]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POSTї'info_dk'])
   && !empty($_POSTї'info_uk'])
   && !empty($_POSTї'land'])
   && !empty($_POSTї'vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id&quote;;

(line 61)              $result = sqlite_query($handle, $query) or die(&quote;Error in query:      &quote;.sqlite_error_string(sqlite_last_error($handle)));
		}
}[/phpote;;
	
   if (!empty($_POST['title'])
   && !empty($_POSTї'info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id&quote;;

(line 61)              $result = sqlite_query($handle, $query) or die(&quote;Error in query:      &quote;.sqlite_error_string(sqlite_last_er)) {


			$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 = &quote;UPDATE $table SET 
                       title='$ti
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POSTї'land'])
   && !empty($_POSTї'vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk', line 61] sqlite_query() [function.sqlite-query]: near "ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POSTї'info_uk'])
   && !empty($_POSTї'land'])
   && !empty($_POSTї'vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id&quote;;

(line 61)              $result = sqlite_query($handle, $query) or die14785]
echo "Update";
	
   if (!empty($_POSTї'title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POSTї'land'])
   && !empty($_POSTї'vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id&quote;;


my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = "UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id";

(line 61)              $result = sqlite_query($handle, $query) or die("Error in query:      ".sqlite_errorite_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 = "UPDATE $table SET 
                       title='$title',
                       infmp;amp;& !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = "UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id";

(line 61)              $result = sqlite_query($handle, $query) or die("Error in query:      ".sqlite_error_string(sqlite_last_error($handle)));
		}
}
where can the error be? i cant find it...n query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo &quote;Update&quote;;
	
   if (!empty($_POSTї'title'])
   && !empty($_POSTї'info_dk'])
   && !empty($_POSTї'info_uk'])
   && !empty($_POSTї'land'])
   && !empty($_POSTї'vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id&quote;;

(line 61)              $result = sqlite_]
UpdateError: [2 at line 61] sqlite_query() [function.sqlite-query]: near "ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 ]
echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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']);
			$voe 61] sqlite_query() [function.sqlite-query]: near "ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo &quote;Update&quote;;
	
   if (!empty($_POSTї'title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = &am line 61] sqlite_query() [function.sqlite-query]: near "ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo &quote;Update&quote;;
	
   if (!empty($_POSTї'title'])
   && !empty($_POSTї'info_dk'])
   && !empty($_POSTї'info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SE85]
UpdateError: [2 at line 61] sqlite_query() [function.sqlite-query]: near "ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = "UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id";

(line 61)              $result = sqlite_query($handle, $query) or die("Error in query:      ".sqlite_error_string(sqlite_last_error($handle)));
		}
}
where can the error be? i cant find it...ax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo &quote;Update&quote;;
	
   if (!empty($_POSTї'title'])
   && !empty($_POSTї'info_dk'])
   && !empty($_POSTї'info_uk'])
   && !empty($_POSTї'land'])
   && !empty($_POSTї'vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$prie]
UpdateError: [2 at line 61] sqlite_query() [function.sqlite-query]: near "ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo &quote;Update&quote;;
	
   if (!empty($_POSTї'title'])
   && !empty($_POSTї'info_dk'])
   && !empty($_POSTї'info_uk'])
   && !empty($_POSTї'land'])
   && !empty($_POSTї'vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id&quote;;

(line 61)              $result = sqlite_query($handle, $query) or die(&quote;Error in query:      &quote;.sqlite_error_string(sqlite_last_1] sqlite_query() [function.sqlite-query]: near "ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POSTї'info_uk'])
   && !empty($_POSTї'land'])
   && !empty($_POSTї'vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
            .sqlite-query]: near "ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo &quote;Update&quote;;
	
   if (!empty($_POSTї'title'])
   && !empty($_POSTї'info_dk'])
   && !empty($_POSTї'info_uk'])
   && !empty($_POSTї'land'])
   && !empty($_POSTї'vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id&quote;;

(line 61)              $result = sqlite_query($handle, $query) or die(&quote;Error in query:      &quote;.sqlite_error_string(sqlite_last_error($handle)));
		}
}
where can the error be? i cant find it..te]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = "UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id";

(line 61)              $result = sqlite_query($handle, $query) or die("Error in query:      ".sqlite_error_string(sqlite_last_error($handle)));
		}
}
where can the error be? i cant find it...
UpdateError: [2 at line 61] sqlite_query() [function.sqlite-query]: near "ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = "UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id";

(line 61)              $result = sqlite_query($handle, $query) or die("Error in query:      ".sqlite_error_string(sqlite_last_error($handle)));
		}
}
where can the error be? i cant find it...function.sqlite-query]: near "ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = "UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id";

(line 61)              $result = sqlite_query($handle, $query) or die("Error in query:      ".sqlite_error_string(sqlite_last_error($handle)));
		}
}
where can the error be? i cant find it...
UpdateError: [2 at line 61] sqlite_query() [function.sqlite-query]: near "ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = "UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id";

(line 61)              $result = sqlite_query($handle, $query) or die("Error in query:      ".sqlite_error_string(sqlite_last_error($handle)));
		}
}
whuery]: near "ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POSTї'info_dk'])
   && !empty($_POSTї'info_uk'])
   && !empty($_POSTї'land'])
   && !empty($_POSTї'vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id&quote;;

(line 61)              $result = sqlite_query($handle, $query) or die(&quote;Error in query:      &quot791514785]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = "UPDATE $table S   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = "UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id";

(line 61)              $result = sqlite_query($handle, $query) or die("Error in query:      ".sqlite_error_string(sqlite_last_error($handle)));
		}
}
where can the error be? i cant find it...p;& !empty($_POST['land'])
&& !empty($_POST['vol'])
&& !empty($_POST['size'])
&& !empty($_POSTї'price'])) {


$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 = &quote;UPDATE $table SET
uery() [function.sqlite-query]: near "ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POSTї'info_uk'])
   && !empty($_POSTї'land'])
   && !empty($_POSTї'vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$printax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = "UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id";

(line 61)              $result = sqlite_query($handle, $query) or die("Error in query:      ".sqlite_error_string(sqlite_last_error($handle)));
		}
}
where can the error be? i cant find it...e;;

if (!empty($_POST['title'])
&& !empty($_POST['info_dk'])
&& !empty($_POST['info_uk'])
&& !empty($_POST['land'])
&& !empty($_POSTї'vol'])
&& !empty($_POSTї'size'])
&& !empty($_POSTї'price'])) {


$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 = &quote;UPDATE $table SET
title='$title',
info_dk='$info_dk',
info_uk='$info_uk',
land='$land',
vol='$vol',
size='$size',

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = "UPDATE $table SET 
                       title='$title',
                mpty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = &quote;UPDATE $table SET 
514785]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POSTї'title'])
   && !empty($_POSTї'info_dk'])
   && !empty($_POSTї'info_uk'])
   && !empty($_POSTї'land'])
   && !empty($_POSTї'vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id&quote;;

(line 61)              $result = sqlite_query($handle, $query) or die(&quote;Error in query:      &quote;ery: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POSTї'info_uk'])
   && !empty($_POSTї'land'])
   && !empty($_POSTї'vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
query]: near "ce9ab0ea3efc99915166ee6350537": syntax error
Error in query: SQL logic error or missing database
[/quote]

my code:

Code: Select all

echo &quote;Update&quote;;
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POSTї'info_uk'])
   && !empty($_POSTї'land'])
   && !empty($_POSTї'vol'])
   && !empty($_POSTї'size'])
   && !empty($_POSTї'price'])) {


			$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 = &quote;UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size'
echo "Update";
	
   if (!empty($_POST['title'])
   && !empty($_POST['info_dk'])
   && !empty($_POST['info_uk'])
   && !empty($_POST['land'])
   && !empty($_POST['vol'])
   && !empty($_POST['size'])
   && !empty($_POST['price'])) {


			$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 = "UPDATE $table SET 
                       title='$title',
                       info_dk='$info_dk',
                       info_uk='$info_uk',
                       land='$land',
                       vol='$vol',
                       size='$size',
                       price='$price'
                       WHERE item_id=$id";

(line 61)              $result = sqlite_query($handle, $query) or die("Error in query:      ".sqlite_error_string(sqlite_last_error($handle)));
		}
}
where can the error be? i cant find it...
Post Reply