Update record

[robfog]

Greetings

I'm trying to get the information from one field to update to the same field in other records with the same user ID.

This is what I have so far but it doesn't seem to work for every field.

Any suggestions?

$result=mysql("$DBName","SELECT Age FROM Data WHERE UserID='$UserID'");
while ($row=mysql_fetch_row($result)) {
$DB=$row[0];
}

mysql("$DBName","UPDATE Data SET Age='$DB' WHERE UserID='$UserID'");

[treds1]

if the [0] a field in the table?

i think you may need something more like

$DB=$row['Age'];

hope this helps

[Frederick]

$sql = mysql_query("SELECT * FROM data WHERE userID=$userID")
or die(mysql_error());
$row = mysql_fetch_array($sql);
    $str = $row["Age"];

$sql = mysql_query("UPDATE data SET Age='$str' WHERE userID=$userID")
or die(mysql_error());

[robfog]

Thanks gives me something to ponder.