update problems

[Anon]

Do you think that mysql/php can update two field in same time? Coding like belowed:

update table1 set col1='$t1' and col2='$t2' where col1= '$f1';

Really appreciate any suggestions.

[tubedogg]

Yup, it would be pretty useless otherwise. 🙂

mysql_query("UPDATE table1 SET col1='$t1',col2='$t2' WHERE col1='$f1'");

[Anon]

You are right. Othewise, mysql is useless. Thanks for your suggestions.

But mysql doesn't allow to update one column by other's talbe's column?

[tubedogg]

You mean update a cell in one table with the contents of a cell from another table?

I'm pretty sure that is not possible just using MySQL. You'd have to do SELECT from one table, then use PHP to UPDATE a second table.

e.g.

<?php

$values = mysql_query("SELECT id,col1,col2 FROM table1") or die "Can't select from table1";
while ($value = mysql_fetch_array($values)) {
mysql_query("UPDATE table2 SET col1='". $value['col1'] ."',col2='". $value['col2'] ."' WHERE id=". $value['id'] .") or die "Can't update table2";
}

?>

Something like that.