Всем доброго дня, подскажите пожалуйста как сделать перевод строки <br/> через определенное количество записей из бд. например через каждые 10 записей

$i=0;
$res = mysql_query("SELECT * FROM table");
while($row = mysql_fetch_assoc($res)){
 echo ($row['data'][$i]%10 == 0) ? "<br />" : $row['data'];
$i++;
}

$i=0;
$res = mysql_query("SELECT * FROM table");
while($row = mysql_fetch_assoc($res)){
 echo ($row['data'][$i]%10 == 0) ? "<br />" : $row['data'];
$i++;
}

$res = mysql_query("SELECT * FROM `map`");
while($row = mysql_fetch_array($res)){

if (($row['id']-1)%10 == 0) echo '<br/>';
echo $row['id'];

}

вроде работает, если это не точный вариант, подскажите как правильнее, спасибо

$count = 1;

$res = mysql_query("SELECT * FROM `map`");
while($row = mysql_fetch_array($res)){

echo $row['id'];

if ($count%10 == 0) echo '<br/>';

$count++;

if($count > 10) $count = 1;
}

_____________
Mysql, Postgresql, Redis, Memcached, Unit Testing, CI, Kohana, Yii, Phalcon, Zend Framework, Joomla, Open Cart, Ymaps, VK Api

$count = 1;

$res = mysql_query("SELECT * FROM `map`");
while($row = mysql_fetch_array($res)){

echo $row['id'];

if ($count%10 == 0) echo '<br/>';

$count++;

if($count > 10) $count = 1;
}

$sql = "SELECT ....";

$query = mysql_query($sql);

if(!mysql_num_rows($query))
    echo 'table is empty';
else
{ 
  $i=0;
   
   while(mysql_fetch_assoc($query))
   { 
       $i++;
 
       if($i%10==0)
          echo '<br />';

       //Data on table
   }
}

_____________
HTML, CSS (Bootstrap), JS(JQuery, ExtJS), PHP, MySQL, MSSql, Posgres, (TSql, BI OLAP, MDX), Mongo, Git, SVN, CodeIgnater, Symfony, Yii 2, JiRA, Redmine, Bitbucket, Composer, Rabbit MQ, Amazon (SQS, S3, Transcribe), Docker

Игорь, инкремент забыл.

_____________
There never was a struggle in the soul of a good man that was not hard

Не верю! Что то не так делаете. Специально поставил и запустил.

_____________
Mysql, Postgresql, Redis, Memcached, Unit Testing, CI, Kohana, Yii, Phalcon, Zend Framework, Joomla, Open Cart, Ymaps, VK Api

код покажи

я пофиксил

_____________
HTML, CSS (Bootstrap), JS(JQuery, ExtJS), PHP, MySQL, MSSql, Posgres, (TSql, BI OLAP, MDX), Mongo, Git, SVN, CodeIgnater, Symfony, Yii 2, JiRA, Redmine, Bitbucket, Composer, Rabbit MQ, Amazon (SQS, S3, Transcribe), Docker

$sql = "SELECT * FROM `map`";

$query = mysql_query($sql);

if(!mysql_num_rows($query))
    echo 'table is empty';
else
{ 
  $i=0;
   
   while(mysql_fetch_assoc($query))
   { 
       $i++;
 
       if($i%10==0)
          echo '<br />';

       //Data on table
   }
}

what? this is example 100% is worked

_____________
HTML, CSS (Bootstrap), JS(JQuery, ExtJS), PHP, MySQL, MSSql, Posgres, (TSql, BI OLAP, MDX), Mongo, Git, SVN, CodeIgnater, Symfony, Yii 2, JiRA, Redmine, Bitbucket, Composer, Rabbit MQ, Amazon (SQS, S3, Transcribe), Docker