I am trying to update about 11,000 records in the mysql database, I can't do it with the following code:
$pQuery = mysql_query("select * from products where products_image not like '%.jpg%'");
while ($pResult=mysql_fetch_array($pQuery)){
$pid = $pResult["products_id"];
$frontIm .= "<img src=http://localhost.com/images/covers/";
$frontIm .= "$pid";
$frontIm .= ".jpg>";
$uQuery = mysql_query("update products set products_image = '$frontIm' where products_image = '$pid' and products_image not like '%.jpg%'");
$frontIm = "";
}
Mysql times out with this, is there another way I can do this?
Much Apreciated!
