Welcome to WebmasterWorld Guest from 220.127.116.11
I have all required permissions and both tables match id for id. But this script does not update even though it seems to follow the syntax in the manual. The request to the table membersid is successful and brings in the value I need.
(any value xxxxx is for security reasons :)
// connect to database
$db = mysql_connect("localhost", "xxxxx", "xxxxx");
// get value from existing column
$result = mysql_query("SELECT * FROM membersid WHERE id=$id");
$myrow = mysql_fetch_array($result);
// update new column
$result1 = mysql_query("UPDATE members SET actualid=$actualid WHERE id=$id");
As always, thanks in advance for any help.