Code: Select all
$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;Matt
Moderator: General Moderators
Code: Select all
$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;rbpd5015 wrote: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?
Thanks,Code: Select all
$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;
Matt
Code: Select all
$get_values = mysql_fetch_array($result);
$target_field = $get_values['pc'];
echo $target_field;