jeudi 14 juillet 2016

How to insert data between mysql fetched result in php?

I'm trying to insert a new predefined data after 6th line while fetching result from mysql in php. After that, I want to insert a predefined text after every 5th line.

while($row=mysql_fetch_array($result))
{

if((($i%6)== 0)&&($i!=0))
{

$emparray['category'] = "PREDEFINED DATA";
array_push($json_response,$emparray);

}

//Data from the database
$emparray['category'] = ucwords($row["tag"]);
array_push($json_response,$emparray);
++$i;
}

This is my code that I had managed but it gives me "PREDEFINED DATA" after every 6th line. What I want is that after 6th line message should be shown after every 5th line.

Aucun commentaire:

Enregistrer un commentaire