I have a select and is limited at 525 results otherwise the while will stuck.
$query_other = "SELECT * FROM prod where active=1 and aprobat=1";
$other = mysql_query($query_other, $conn) or die(mysql_error());
while($row = mysql_fetch_assoc($other)){
$other_prod[]=$row;
}
In cpanel it shows more than 525 and when i did var_dump on $other its says resource(525) of type (mysql result). Its on Apache Server if that helps.
If i put LIMIT 525 it works and show all page otherwise is just blank page. Anything after the while doesn't work.
P.S : I know mysql_ is deprecated i hate it but is required at the task and i have no power over it.