PHP SQL UPDATE Query issue

Question

I'm having trouble with this update query.INSERT works absolutely fine.My INSERT query and UPDATE query as follows,

This is the error that i've been getting.

db_exec:DB Error: 
 (UPDATE vms2 set invoiceid='', slicenseinfo='testVM',  
   manufacturerid='692', hyp='6', stitle='UBER', vmg='UBER', sversion='1716',  sinfo='', 
   purchdate='1367712000', licqty='7', lictype='192', dns='', ipv4='10.2.36.3', ipv4dns='102.32.3.55', 
    remip='110.2.3.3', remipdns='100.32.3.32', ipv6='', 
    hdd='', ram='', cores='',  WHERE id=14): 
    near "WHERE": syntax error


Array
(
    [0] => Array
        (
            [file] => C:\xampp\htdocs\test\php\editvm.php
            [line] => 149
            [function] => db_exec
            [args] => Array
                (
                    [0] => PDO Object
                        (
                        )

                    [1] => UPDATE vms2 set invoiceid='', slicenseinfo='testVM',  manufacturerid='692', hyp='6', stitle='UBER', vmg='UBER', sversion='1716',  sinfo='', purchdate='1367712000', licqty='7', lictype='192', dns='', ipv4='10.2.36.3', ipv4dns='102.32.3.55', remip='110.2.3.3', remipdns='100.32.3.32', ipv6='', hdd='', ram='', cores='',  WHERE id=14
                )

        )

    [1] => Array
        (
            [file] => C:\xampp\htdocs\test\index.php
            [line] => 490
            [args] => Array
                (
                    [0] => C:\xampp\htdocs\test\php\editvm.php
                )

            [function] => require
        )

)

Thanks for your help :)

You should not have , after the last value. But without seeing the code that generates the query, further help is impossible — Maxim Krizhanovsky
– Maxim Krizhanovsky, Commented Sep 24, 2013 at 8:51

calcinai · Accepted Answer · 2013-09-24 08:52:12Z

1

Remove the last comma before the WHERE

answered Sep 24, 2013 at 8:52

calcinai

2,62716 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

aaron · Accepted Answer · 2013-09-24 08:54:14Z

0

You have an extra comma before the Where clause which is not required

UPDATE vms2 set invoiceid='', slicenseinfo='testVM',  manufacturerid='692', hyp='6', stitle='UBER', vmg='UBER', sversion='1716',  sinfo='', purchdate='1367712000', licqty='7', lictype='192', dns='', ipv4='10.2.36.3', ipv4dns='102.32.3.55', remip='110.2.3.3', remipdns='100.32.3.32', ipv6='', hdd='', ram='', cores=''  WHERE id=14

This should work.

answered Sep 24, 2013 at 8:54

aaron

6874 silver badges11 bronze badges

Comments

Sobin Augustine · Accepted Answer · 2013-09-24 08:54:31Z

0

Update the UPDATE command to this

 UPDATE vms2 set invoiceid='', slicenseinfo='testVM',  manufacturerid='692', hyp='6', stitle='UBER', vmg='UBER', sversion='1716',  sinfo='', purchdate='1367712000', licqty='7', lictype='192', dns='', ipv4='10.2.36.3', ipv4dns='102.32.3.55', remip='110.2.3.3', remipdns='100.32.3.32', ipv6='', hdd='', ram='', cores=''  WHERE id=14`

answered Sep 24, 2013 at 8:54

Sobin Augustine

3,7752 gold badges28 silver badges43 bronze badges

1 Comment

Carter Over a year ago

it was the comma before "cores" .thnaks for your help

Collectives™ on Stack Overflow

PHP SQL UPDATE Query issue

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related