Jump to content


Photo

A Simple SQL Update Via PHP


  • Please log in to reply
3 replies to this topic

#1 NFD

NFD
  • Members
  • PipPipPip
  • Advanced Member
  • 44 posts

Posted 28 October 2006 - 08:27 PM

Hi,

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 :)

#2 pendelton

pendelton
  • Members
  • PipPip
  • Member
  • 20 posts
  • LocationUK

Posted 29 October 2006 - 12:44 AM

Have you tried using phpmyadmin to see what is going on?

#3 corbin

corbin
  • Staff Alumni
  • Advanced Member
  • 8,129 posts

Posted 29 October 2006 - 05:09 AM

UPDATE `table1` SET `test_id` = 'table2.test_id' WHERE `table1.group` = 'table2.group';

I doubt thats it, but worth a try :P.
Why doesn't anyone ever say hi, hey, or whad up world?

#4 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 29 October 2006 - 12:03 PM

I think it's
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
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|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