Returning Field Data

[rbpd5015]

I am trying to use the field pc from the Query below in an update query later in my script. How do I do I refer to the field pc?


$query = "SELECT sum(cmp) as pc FROM $weeklydb_table WHERE id = $id AND year = $year AND wk < $wk ";
$result = @mysql_query($query);
if ($result == false)
{
echo "No Data";
}

# echo $result;

echo pc;


Thanks,
Matt

[Velox Letum]

$query = "SELECT sum(cmp) as pc FROM $weeklydb_table WHERE id = $id AND year = $year AND wk < $wk ";
$result = @mysql_query($query);
if ($result == false)
{
echo "No Data";
}

$result = mysql_fetch_assoc($result);

echo $result['pc'];