10 new time will eqaul rand(11,20), if $min > 20, rand(21,30), etc....
}else {
//die();
}
$sql = "SELECT * FROM `list_items` WHERE `type` ='Food'";
$res = mysql_query($sql) or die(mysql_error());
$array = array();
$arra2 = array();
$arra3 = array();
$arra4 = array();
$total = mysql_num_rows($res);
while ($row = mysql_fetch_assoc($res)) {
$array[] = $row['ID'];
$arra2[] = $row['itemname'];
$arra3[] = $row['url'];
$arra4[] = $row['price'];
}
foreach($array as $val AND $arra2 as $val2 AND $arra3 as $val3 AND $arra4 as $val4) {
$array = "$val,";
$arra2 = "$val2,";
$arra3 = "$val3,";
$arra4 = "$val4,";
echo "$array
";
echo "$arra2
";
echo "$arra3
";
echo "$arra4
";
}
$num = rand(1,$total);
//for ($i = 0;$i <= $num; $i++)
//if (mysql_query("INSERT INTO `shopstock` (`itemid`,`item_name`,`url`,`price`) VALUES ('$array[$i]','$arra2[$i]','$arra3[$i]','$arra4[$i]');")) {
// echo $array[$i]." inserted";
//}
//}
?>