how to update multiple rows of data in mysql data base with php.?
<?php
include 'db.php';
$i = 1;
while ($i <= 100) {
$i++;
$sql = mysql_query("UPDATE table_name SET str = 'abcdef' WHERE id = '$i'") or die (mysql_error());
}
?>
include 'db.php';
$i = 1;
while ($i <= 100) {
$i++;
$sql = mysql_query("UPDATE table_name SET str = 'abcdef' WHERE id = '$i'") or die (mysql_error());
}
?>
how to update multiple rows of data in mysql data base with php.?
![how to update multiple rows of data in mysql data base with php.?]()
Reviewed by MCH
on
May 22, 2014
Rating:
No comments: