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'");

My first attempt would be to implement wildcards after SELECT and UPDATE.

I think it'll require a little bit more then just a wildcard

In that case, divulge a little bit more as to what is actually going on. The sort of information that is being processed, etc.

This should do the trick:


<?php

$rs = mysql_query("SELECT * FROM rate_mem");
if($rs) {
while($row = mysql_fetch_assoc($rs)) {

$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'];

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 = '".$row['m_id']."'");
}
}

?>

This should do the trick:


<?php

$rs = mysql_query("SELECT * FROM rate_mem");
if($rs) {
while($row = mysql_fetch_assoc($rs)) {

$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'];

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 = '".$row['m_id']."'");
}
}

?>



thanks, everything worked