Updating one Table from Another ( PHP )

[Jayson A]

Hello,

I've spent some time on this and i can't seem to get it, I'm trying to update one table from another via certain conditions. Please see code below.


Everything works but the SET and WHERE command ( The JOS is Table1 and Product_price is Table 2 ) It keeps setting the field as the first character 'p'

SET jos_vm_product.product_publish = product_price_update.product_publish

WHERE jos_vm_product.product_sku = product_price_update.product_sku'

Anything you can do to help is much appreciated.




<?php
include 'config.php';
include 'opendb.php';

// ... do something like insert or select, etc

$sql = 'UPDATE jos_vm_product, product_price_update
SET jos_vm_product.product_publish = product_price_update.product_publish
WHERE jos_vm_product.product_sku = product_price_update.product_sku';

mysql_select_db('example');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not update data: ' . mysql_error());
}
echo "Updated data successfully\n";

include 'closedb.php';
?>



Edited 1 time(s). Last edit at 06/02/2010 07:08AM by Jayson A.