I am still quite new to MySQL and have a basic question. I am using PHP, so
forgive me if this is more a PHP issue.
I want to perform an update to a specific record based on a condition. In
the outer loop, I have Query1, which returns set Result1. Inside this loop,
I run an UPDATE query which returns Result2.
// executed first query.
while ($row = mysql_fetch_assoc($result1))
{
// get the record ID for the row we are on.
$recid = $row["id"];
// construct a new query
$q2 ="UPDATE `table` SET `review` = 1 where id =
'".$recid."';";
$result2 = mysql_query($q2)
}
Is this a valid use of MySQL? I am concerned that executing the update
query might somehow effect the first one that is used in the outer loop.
Mark Richards
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
