28-04-2012, 20:04
|
|
|
חבר מתאריך: 12.08.05
הודעות: 883
|
|
אחלה.. אגב:
קוד PHP:
function reductionStors()
{
$r = 0;
$queryUpdate = "";
$query = mysql_query("SELECT `id`,`store` FROM `items`
WHERE items.store IN (SELECT `store` FROM `items` GROUP BY `store` HAVING COUNT(id)<10)
ORDER BY `store`") or die("Query faild: " . mysql_error());
while($results = mysql_fetch_assoc($query))
{
$itemId = $results['id'];
if($r % 10 == 0)
$storeId = $results['store'];
$queryUpdate .= "UPDATE items SET `store`='$storeId' WHERE `id`='$itemId'";
$r++;
}
$runQuery = mysql_query($queryUpdate) or die("Query faild: " . mysql_error());
}
|