php - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near at line 1 -


this upadating script--

        $cno = $data[6];          $result = mysql_query("select *                                 courier_details                                 consignment_no = '".$cno."'");              if($result >0)            {                    $update = "update `courier_details`                      set(`shipper_name`, `shipper_phone`, `shipper_address`, `receiver_name`,                         `receiver_phone`, `receiver_address`, `consignment_no`,                         `type_of_shippment`, `weight`, `volumetric_weight`, `packages`,                         `product`, `qnty`, `booking_mode`, `total_freight`, `mode`,                         `dept_time`, `origin`, `destination`, `pickup_date`, `pickup_time`,                        `status`, `excepted_dly_date`, `comments`, `delivered_date`,                        `delivered_time`, `deboy`, `career`,`originbr`, `destinationbr`,                        `email`)                    values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]',                          '$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]',                          '$data[12]','$data[13]','$data[14]','$data[15]','$data[16]',                          '$data[17]','$data[18]','$data[19]','$data[20]','$data[21]',                          '$data[22]','$data[23]','$data[24]','$data[25]','$data[26]',                          '$data[27]','$data[28]','$data[29]','$data[30]')                   `consignment_no` = '".$cno."'";                                 mysql_query($update) or die(mysql_error());          }

there show error while execute code--

you have error in sql syntax; check manual corresponds mysql server version right syntax use

near '(shipper_name, shipper_phone, shipper_address, receiver_name, `receiver_' @ line 1

your update query seems wrong.

you cannot use update query insert query. syntax should be:

update tablename set col1=val1,     col2=val2,     col3=val3, .......

on other hand, insert can used like:

insert tablename  (col1,col2,col3) values (val1,val2,val3)

Comments

Post a Comment

Popular posts from this blog

node.js - Using Node without global install -

i'm working on few node & electron (atom shell) projects , i'm curious how them work without user having install node globally. i've seen few applications including node directory in project contains node.exe binary. how go setting node project use binary? edit: thought should add, i've searched everywhere answer this, unrelated results.
Read more

How to access a php class file from PHPFox framework into javascript code written in simple HTML file? -

i've website developed using phpfox v3.0.7 . now i'm trying implement 'sse(server sent events)' 1 of php files. reference i'm giving below necessary code part of file. file titled process.class.php , present @ location /var/www/module/notification/include/service/process.class.php present on server having ip http://34.124.40.142/ . <?php /** * [phpfox_header] */ header('content-type: text/event-stream'); header('cache-control: no-cache'); defined('phpfox') or exit('no dice!'); /** * * * @copyright [phpfox_copyright] * @author raymond benc * @package phpfox_service * @version $id: service.class.php 67 2009-01-20 11:32:45z raymond_benc $ */ class notification_service_process extends phpfox_service { /** * class constructor */ public function __construct() { $this->_stable = phpfox::gett('notification'); } public function add($...
Read more

java - Null response to php query in android, even though php works properly -

Image
table i'm trying retrieve above data using 2 php files below. want pass email parameter , return bets user = email. work fine when tested advanced rest client, problem not php. however, when try through android 2 java classes below, null pointer exception (logcat below) , json object returned null. i'm not sure error is, think i'm not passing parameter php , that's why it's producing null response. logcat 05-31 15:10:50.227 26074-26074/com.example.albert.betterapp e/androidruntime﹕ fatal exception: main process: com.example.albert.betterapp, pid: 26074 java.lang.runtimeexception: unable start activity componentinfo{com.example.albert.betterapp/com.example.albert.betterapp.displayallbets}: java.lang.nullpointerexception @ android.app.activitythread.performlaunchactivity(activitythread.java:2292) @ android.app.activitythread.handlelaunchactivity(activitythread.java:2350) @ android.app.activitythread.acce...
Read more