query

monion

What is the easiest way to format a 1 record query of select * from....
When I have maybe 40 or 50 fields/columns in a row and I want the format to be
col1
col2
col3 col4 col5 col6
col7 col8 col9 col10
col11 col12 col13 col14

so basically col1 (id)
col2 timestamp

col3-col??? data, but I want the data to print 4 per line.

Thanks,
MO

Dormilich

one possibility (pseudo code):

Expand|Select|Wrap|Line Numbers

 // open table, open row
 
// table cell display 1&2
 
while ($result-set)

{

  // table row after 4 cells

  if (0 == $i % 4)

  {

    echo "</tr><tr>";

  }
 
  // table cell display …
 
  // count table cells

  $i++;

}
 
// fill table cells until $i mod 4 = 0, close row, close table

for the first two rows, apply the easiest thinkable code.

query

re: query

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about