Updating multiple rows in mysql with PHP

Question

which is creating this table:

Table createb by PHP with MySQL data

Every row have two inputs. My DB table has AUTO_INCREMENT 'ID' field.

How can I update my DB Table and make sure that rows will be updated accordingly to the ID's (auto incremented field)?

I'm must admit that SQL with PHP is very new to me and I don't know is this correct way of doing it?

            $news_SQLupdate = "UPDATE news SET ";   // table name is 'news'     
            $news_SQLupdate .=  "LIVE= '".$LIVE."', ";
            $news_SQLupdate .=  "CONTENT= '".$CONTENT."', ";
            $news_SQLupdate .=  "WHERE ID = '".$ID."' ";

wonk0 · Accepted Answer · 2011-08-08 13:50:21Z

2

By including the id in the WHERE clause?

UPDATE <someTable> SET ... WHERE id = <someId>

answered Aug 8, 2011 at 13:50

wonk0

14.1k1 gold badge23 silver badges15 bronze badges

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

Comments

Kyle · Accepted Answer · 2011-08-08 13:49:08Z

0

In your update statement, you will need a where id=(the id number)

Simple example:

UPDATE table_name set field1=value1 where id=1

answered Aug 8, 2011 at 13:49

Kyle

4,46124 silver badges33 bronze badges

Comments

JMichelB · Accepted Answer · 2011-08-08 13:59:54Z

0

UPDATE `tblContent` SET `On/Off` = true WHERE (`ID` = 1 OR `ID` = 2)

Dynamicaly add a OR ID = X in the where clause to apply the changes to another record.

answered Aug 8, 2011 at 13:59

JMichelB

4753 silver badges8 bronze badges

Comments

saravanan · Accepted Answer · 2011-08-08 14:43:40Z

0

"UPDATE table_name SET column_name1=' value[$array]', column_name2=' value[$array]' WHERE column_name=' value[$array]' ";

answered Aug 8, 2011 at 14:43

saravanan

1455 bronze badges

Comments

slavoo · Accepted Answer · 2015-02-06 08:47:51Z

0

I tried this one state above:

UPDATE table_name 
SET column_name1=' value[$array]', 
    column_name2=' value[$array]' 
WHERE column_name=' value[$array]' ;

Just confirming that it worked for me perfectly.

edited Feb 6, 2015 at 8:47

slavoo

6,11464 gold badges40 silver badges41 bronze badges

answered Feb 6, 2015 at 8:42

Rookie Recruits

933 silver badges20 bronze badges

Collectives™ on Stack Overflow

Updating multiple rows in mysql with PHP

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related