php - Mupdate sql query return an error: limit 1 -

- 

<?php  // find current order         $current_order_id = find_order_by_id($_get['order']);        if(!$current_order_id){          redirect_to("orders.php");        } ?>  <?php       $id = $current_order_id["id"];       $menu_name = $_post["menu_name"];       $address = $_post["address"];       $contact = $_post["contact"];       $transaction = $_post["transaction"];       $flemingia = $_post["flemingia"];       $goat_manual = $_post["goat_manual"];       $lbc_tracking_no = $_post["lbc_tracking_no"];       $visible = $_post["visible"];         $query  = "update orders set ";       $query .= "menu_name = '{$menu_name}', ";       $query .= "address = '{$address}', ";       $query .= "contact = {$contact}, ";       $query .= "transaction = '{$transaction}', ";       $query .= "flemingia = {$flemingia}, ";       $query .= "goat_manual = {$goat_manual}, ";       $query .= "lbc_tracking_no = {$lbc_tracking_no}, ";       $query .= "visible = {$visible} ";       $query .= "where id = {$id} ";       $query .= "limit 1";       $result = mysqli_query($connection, $query);       if($result){         die("database connection failed. " . mysqli_error($connection));       } ?>

and error got: database connection failed:you have error in sql syntax; check manual corresponds mysql server version right syntax use near 'limit 1' @ line 1

can explain why happen

i suspect pickup wrong id echo query , got! right id

output of query:

update orders set menu_name = '', address = '', contact = , transaction = '', flemingia = , goat_manual = , lbc_tracking_no = , visible = id = 20 limit 1

note: contact, flemingia, goat_manual, lbc_tracking_no, visible int

===============================update===================================

my form

<h1>create order : <?php echo $current_order_id["menu_name"]; ?></h1> <p class="error"><?php echo $message; ?></p> <form action="edit_order.php" method="post"> <p><span>name</span>: <input type="text" name="menu_name" value="<?php echo $current_order_id["menu_name"]; ?>" /> </p> <p><span>address</span>: <input type="text" name="address" value="<?php echo $current_order_id["address"]; ?>" /> </p> <p><span>contact number</span>: <input type="text" name="contact" value="<?php echo $current_order_id["contact"]; ?>" /> </p> <p><span>transaction</span>: <input type="text" name="transaction" value="<?php echo $current_order_id["transaction"]; ?>" /> </p> <p><span>flemingia</span>: <input type="text" name="flemingia" value="<?php echo $current_order_id["flemingia"]; ?>" /> </p> <p><span>goat manual</span>: <input type="text" name="goat_manual" value="<?php echo $current_order_id["goat_manual"]; ?>" /> </p> <p><span>lbc tracking no.</span>: <input type="text" name="lbc_tracking_no" value="<?php echo $current_order_id["lbc_tracking_no"]; ?>" /> </p> <p><span>visible</span>: <input type="radio" name="visible" value="0" <?php if($current_order_id["visible"] == 0){echo "checked";} ?> />no <input type="radio" name="visible" value="1" <?php if($current_order_id["visible"] == 1){echo "checked";}?> />yes </p> <input class="submit_btn" type="submit" name="submit" value="edit order" /> </form>

this function

<?php      function redirect_to($new_location){        header("location:" . $new_location);        exit;      }      function confirm_query($result_set){        if(!$result_set){       die("database connection failed. ");     }     }      function find_all_order(){       global $connection;        $query  = "select * ";       $query .= "from orders";       $order_set = mysqli_query($connection, $query);       confirm_query($order_set);       return  $order_set;     }     function find_order_by_id($order_id){       global $connection;        $query  = "select * ";       $query .= "from orders ";       $query .= "where id = {$order_id} ";       $query .= "limit 1";       $orderset = mysqli_query($connection, $query);       if(!$orderset){         die("database connection failed:" . mysqli_error($connection));       }       if($order = mysqli_fetch_assoc($orderset)){       return $order;       }else{         return null;       }     }   ?>

i think know problem is. need use multi_query() function.

try this: 

if(!$connection->multi_query($query)){  echo "multi query failed: (" . $connection->errno . ") " . $connection->error; }

instead of $result = mysqli_query($connection, $query);

edit

try method then:

 $query  = "update orders set menu_name = '$menu_name', address = '$address',   contact = $contact, transaction = '$transaction', flemingia = $flemingia,   goat_manual = $goat_manual, lbc_tracking_no = $lbc_tracking_no, visible = $visible    id = $id limit 1";   $result = mysqli_query($connection, $query);    if(!$result){     die("database connection failed. " . mysqli_error($connection));   }    else{   echo "success";   }

or:

 $query  = "update orders set menu_name = '".$menu_name."', address = '".$address."',   contact = $contact, transaction = '".$transaction."', flemingia = $flemingia,   goat_manual = $goat_manual, lbc_tracking_no = $lbc_tracking_no, visible = $visible    id = $id limit 1";   $result = mysqli_query($connection, $query);    if(!$result){     die("database connection failed. " . mysqli_error($connection));   }    else{   echo "success";   }

however, if of entries contain hyphens, factor.

original answer

you have quotes missing of variables:

{$flemingia} - {$goat_manual} - {$lbc_tracking_no} - {$visible}

  $query  = "update orders set ";   $query .= "menu_name = '{$menu_name}', ";   $query .= "address = '{$address}', ";   $query .= "contact = {$contact}, ";   $query .= "transaction = '{$transaction}', ";   $query .= "flemingia = '{$flemingia}', ";   $query .= "goat_manual = '{$goat_manual}', ";   $query .= "lbc_tracking_no = '{$lbc_tracking_no}', ";   $query .= "visible = '{$visible}' ";   $query .= "where id = {$id} ";   $query .= "limit 1";   $result = mysqli_query($connection, $query);

edit: deleted {$contact} list, since op said int

however, may need put them in, since contact = , part of error message, along others.

your {$id} did not have , shows correctly in echo'ed query.


Comments

Post a Comment

Popular posts from this blog

How to access named pipes using JavaScript in Firefox add-on? -

-
i'm trying access named pipe in firefox add-on. code, based on solution 2 this codeproject question, is: var file = components.classes["@mozilla.org/file/local;1"].createinstance(components.interfaces.nsilocalfile); file.initwithpath("\\\\.\\pipe\\test"); var text = "some text written"; var writer = components.classes["@mozilla.org/network/file-output-stream;1"].createinstance(components.interfaces.nsifileoutputstream); // open file read/write access, , create if not exist. writer.init (file, 0x04 | 0x08, -1, 0); writer.write (text, text.length); writer.flush (); writer.close (); when run firefox scratchpad, get: /* exception: component returned failure code: 0x80520012 (ns_error_file_not_found) [nsifileoutputstream.init] @6 */ line 6 line call writer.init. i've played passing different flags writer.init, no luck. i'm able write normal file path code, not named pipe path. i've been searching more information of da...
Read more

multithreading - OPAL (Open Phone Abstraction Library) Transport not terminated when reattaching thread? -

-
i in process of writing application using opal makes h323 calls. have looked online number of working examples , have managed put resembles should like, @ present able call external ip via application when accept call craps out , dies. leaving me with: 0:12.949 setupcall:8752 sert.cxx(259) assertion fail: transport not terminated when reattaching thread , file d:\voip\software\opal\src\opal\transports.cxx, line 1021 passertfunc(0xde3f88, 0xffffffffd228226f, 0, 0) + 0x82 passertfunc(0x10d6e5f8, 0x3fd, 0, 0x10d6eb98) + 0x15b opaltransport::attachthread(0xde5870, 0xffffffffd22fc76b, 0, 0) + 0x96 h323connection::setupconnection(0xffffffffd22fc713, 0, 0, 0xde6ea8) + 0x196 asynchcallsetup(0x10d3572c, 0, 0, 0xdd0108) + 0x7c pthread1arg<psafeptr<opalconnection,psafeptrbase> >::main(0xffffffffd2282faf from have deduced, perhaps incorrectly if there thread lock issue caused (possibly arising fact application sending expected h323 call, throwing in c...
Read more

node.js - req param returns an empty array -

-
i using node.js , mongodb geolocation app , req param returns empty array exports.findpressure = function(req, res) { var queryobject = req.param('q'); console.log(queryobject); db.collection('pressure', function(err, collection) { collection.find( { loc: { $near :[ req.param('q') ] , $maxdistance : 5 }},{"value" : 1, _id : 0}) .sort({_id : -1}).limit(1).toarray(function(err, items) { res.send(items); }); }); }; the longitude , latitude values displayed in console listening on port 3000... connected 'weather' database 8.9068256,52.019347499999995 /pressure?q=8.9068256,52.019347499999995 200 27ms - 2b the url follows http://localhost:3000/pressure?q=8.9068256,52.019347499999995 if use values 8.9068256,52.019347499999995 getting value database if use req.param('q') returning empty array you seem passing values part of query string. req.query.q should contain comma-s...
Read more