A Simple SQL Update Via PHP
Posted 28 October 2006 - 08:27 PM
What I am trying to do is update one field on one table based upon a match of anoother field on another table.
Here is my initial query (at this stage entered via phpmyadmin):
UPDATE `table1` SET `test_id` = 'table2.test_id' WHERE `group` = 'table2.group' ;
Whilst the query itself runs, it affects 0 rows which is unexpected as there are 2000+ matches.
Firstly I need to know what part of the query am I doing incorrectly?
Afterwards, I want to have a go at making it a query run as part of a php file that does alot of data inserts first.
Any help that can be given would be much appreciated
Posted 29 October 2006 - 12:44 AM
Posted 29 October 2006 - 05:09 AM
I doubt thats it, but worth a try .
Posted 29 October 2006 - 12:03 PM
UPDATE `table1`, `table2` SET `table1`.`test_id` = `table2`.`test_id` WHERE `table1`.`group` = `table2`.`group`;BTW, "group" isn't a good choice of column name as it's a MySQL reserved word
Donations gratefully received
|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users