mysql - SQL syntax; check the manual that corresponds to your MariaDB server version - delete query -


i can't tell wrong here, have tried replacing id = '$id' , still not working. removing clause makes works fine. id variable not have problem has it's value. can me figure out? thanks

  $id = $_get['id'];    $status = $con->exec("update wine set confirmstatus = 'confirmed' id = '".$id."' ");

try without enclosing $id- value within ' ':

  $status = $con->exec("update wine set confirmstatus = 'confirmed' id = ".$id);

if works, please still consider gordon's comment regarding using parameters...


-

Comments

Post a Comment

Popular posts from this blog

php - Displaying JSON data posts for blog using just the post id -

i have page named 'posts_list.php' containing list of blog posts retrieved form json api have id, title, image etc . have link on page goes page called 'post.php' below: <a href="post.php?id=<?php echo $post->id ?> "> using method can retrieve 'id' of post clicked user using: <?php $postid = $_get['id']; ?> what want display json post on post.php corresponds id retrieved link on posts_list.php i know sql use clause, being new json im not sure if possible. need achieve php , json it has info /v1/blogs/@blog/@id @blog - blog identifier @id - blog post id
Read more

docusignapi - Documents restrictions within a package -

i have looked through docusign documentation, stackoverflow , google without success. when creating package, possible restrict signers able view pages of document ? let's borrower lisa smith should not allowed see pages 5 10 while second borrower can allowed see pages 1 5, possible within rest api ? thanks you can use docusign document visibility feature. if send document containing multiple files , want control files each recipient sees, can use document visibility accomplish this. common scenario want recipients see files need sign. document visibility, can create 1 document files intended individual recipients, rather having create separate document each recipient. using document visibility can set access @ document level. setting access @ page level not supported. see answer on how set documentvisibility using rest api. for more context, excludeddocuments property on page .
Read more

javascript - angular.forEach loop with $http.get -

i want create array containing objects firstly, first array server containing list of devices [ {accountid : "sysadmin",deviceid : "123"}, {accountid : "sysadmin",deviceid : "3"} ... ] then create second array containing objects each object represent device(deviceid) , contains array of events of device server i loop upon first array : $scope.myarrayofdevices = []; angular.foreach(response, function(device){ $scope.myobject={}; $scope.myobject.device = device.deviceid; $http.get('events') .success(function (data) { $scope.myobject.events = data; }); $scope.myarrayofdevices.push($scope.myobject); });//end loop i events data server correctly . but, when check $scope.myarrayofdevices array first object deviceid , no event array , second object deviceid , events array correctly like : [ {deviceid : 123, events:}, {deviceid : 3 , events : array...
Read more