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);
?>