Using Foreach/Loop on a query

[acctman]

Hi, the current code I wrote below looks up one user ID (m_id = 39) and processes it, how would I process all rows in table rate_mem?

$res = mysql_query("SELECT m_addtn FROM rate_mem WHERE m_id = '39'");
$results = mysql_fetch_array($res,MYSQL_BOTH);

$decode = unserialize(base64_decode($results['m_addtn']));

$m_orientation =     $decode['3'];
$m_status =     $decode['6'];
$m_turn_on =     $decode['4'];
$m_turn_off =     $decode['1'];

mysql_query ("UPDATE rate_members SET
             m_orientation = '$m_orientation',
             m_status = '$m_status',
             m_turn_on = '$m_turn_on',
             m_turn_off = '$m_turn_off'
             WHERE m_id = '39'"); 

[kuau]

I don't know where all the php geniuses are today, but seeing as no one has tried to help you yet, here is my attempt. I have no clue about the decode part but I think this might process all rows in the table. I'm just learning php but hopefully this will help. e

<?php

$sql = " SELECT `m_id` FROM `rate_mem`";
			   
$result = mysql_query($sql,$connection) or die("Couldn't execute $sql query. <br> mysql error: ".mysql_error()); 
$memberList = array();

while ($row = mysql_fetch_array($result))
{
	$member = array();
	$member['id']      = $row['m_id'];
	$member['m_addtn'] = $row['m_addtn'];
	
	$decode = unserialize(base64_decode($row['m_addtn'])); 

	$m_orientation =  $decode['3']; 
	$m_status      =  $decode['6']; 
	$m_turn_on     =  $decode['4']; 
	$m_turn_off    =  $decode['1']; 

	
	$sql = "UPDATE rate_members SET 
             m_orientation = '$m_orientation', 
             m_status = '$m_status', 
             m_turn_on = '$m_turn_on', 
             m_turn_off = '$m_turn_off' 
             WHERE m_id = '".$member['id']."' "; 

	$result2 = @mysql_query($sql,$connection) or die("Couldn't execute $sql query. <br> mysql error: ".mysql_error());
	$row2 = mysql_fetch_array($result2);

	mysql_free_result($result2);
	unset($row2);

	array_push($memberList, $member);
}

?>