Hey guys,
   I am trying to change the values in one column of one table based
on the value in a different table.  So far this is what i have.  I am
only able to change the value based on a preset value i put into this
script.  If anyone knows how I can set **value in another table**  It
would be greatly appreciated.

Thanks

Bill
<?php
$con = mysql_connect("server","database","%*&^(*&(*&");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("database", $con);


mysql_query("UPDATE data SET Column_name = 'Value'
WHERE column_name = **value in another table** ");


mysql_close($con);
?>

On 27 Mar, 00:36, "BillinBoston" <BillinBos...@gmail.com> wrote:
> Hey guys,
>    I am trying to change the values in one column of one table based
> on the value in a different table.  So far this is what i have.  I am
> only able to change the value based on a preset value i put into this
> script.  If anyone knows how I can set **value in another table**  It
> would be greatly appreciated.
>
> Thanks
>
> Bill
> <?php
> $con = mysql_connect("server","database","%*&^(*&(*&");
> if (!$con)
>   {
>   die('Could not connect: ' . mysql_error());
>   }
>
> mysql_select_db("database", $con);
>
> mysql_query("UPDATE data SET Column_name = 'Value'
> WHERE column_name = **value in another table** ");
>
> mysql_close($con);
> ?>

There is an example of this in a special book that we call "The
Manual".

Here: http://dev.mysql.com/doc/refman/5.0/en/update.html

UPDATE items,month SET items.price=month.price
WHERE items.id=month.id;