i have 11 records in a database(MSSQL) i want to dispaly 4 records for a line.(LIKE)
now i have display like this format
***********

I want display like this format
****
****
***

please send me the php code.
thank you

surendran
(Anything is Possible)

__________________
surendran
(Anything is Possible)
http://www.suren.info
http://ssuren.spaces.msn.com

do a loop?
set the loop to display four records, a line break, and then four more records, a line break, and so on.


$total = totalNumberOfRecordsToBeDisplayed;
$break = theNumberOfRecordsDisplayedBetweenLineBreaks;

for($counter=0; $counter<$total; $counter++)
  {
  codeThatDisplaysARecord;
  if($counter == $break)
    {
    echo "<br>";
    }
  }


you'll need to change the code to include the lines needed to get the number of records and display the records, but seeing as you're already successful at displaying the records, it shouldn't be much trouble for you.

Thanks grimmy,
but still i recive this format answer
* * * *
* * * * * * *

this code working like this,
i need like
****
****
***
thanks ,
<?
$total = 11;
$break = 4;
for($counter=0; $counter<$total; $counter++)
  {
  echo "* ";


surendran
(Anything is Possible)

sorry, my mistake! i missed the fact that it needs to count both the total number of records to be displayed and the number of records to be displayed on one line.
the following code should clear that up:

$total = 11; //total number of records to be displayed
$break = 4; //number of records displayed between line breaks
$records = 0; //the number of records already displayed on a single line

for($counter=0; $counter<$total; $counter++)
{
echo "*"; //code that displays a record
$records++;
if($records == $break)
    {
    echo "<br>";
    $records = 0;
    }
}

the above is cut directly from something i tested just a couple of minutes ago and it worked fine. i've made the text in the code into comments, but in essence the red is what i've added or changed to make it work and the output it gave was:
****
****
***

just the way you wanted it, right?
let me know if you have any further problems!

grimmy
God, grant me the serenity to accept the things I cannot change, the courage to change the things I can, and the wisdom to hide the bodies of those people I had to kill because they pissed me off.