原帖由
tinlok 於 2008-10-3 14:54 發表
小弟整緊一個php係click左個連結之後，table_b其中一個field叫 'updated' 裡面o既數 會轉做'0'，但整呢整去都無反應，請各位幫小弟幫幫有咩問題！THX！
table_a o既 username等同 table_b o既name_id！
< ...
<?php
include'../../../common/header.php';
$sql = "SELECT username FROM table_a WHERE allow_use = 1 AND userGroup = 1";
$result = mysql_query($sql) or die(mysql_error());
$total_rows = mysql_num_rows($result);
for($i=0;$i<$total_rows; $i++)
{
$temp = mysql_fetch_row($result);
$new_sql = "UPDATE table_b SET updated = 0 WHERE name_id = '{$temp[0]}'";
mysql_query($new_sql) or die(mysql_error());
}
header('Location: output.php');
exit;
?>
