[thelist] Multiple columns - howto?

[Anthony Baratta]

At 05:35 PM 2/18/2003, Anthony Baratta wrote:
>pseudo code alert
>
>colNmbr = 1
>colCount = 3
>strQuery = "Select Blah Blah Blah"
>Execute Query
>while we have data
>     strRow = db.DataField
>     if colNmbr = 1 then
>        PrintOut "<tr><td>" . strRow . "</td>"
>        colNmbr ++
>     else
>        PrintOut = "<td>" . strRow . "</td>"
>
>     if colNmbr = colCount
>        PrintOut = "<td>" . strRow . "</td></tr>"
>        colNmbr = 1
>end while

For got to add a check for closing up the table properly...

if colNmbr > 1 &&  colNmbr != colCount
   while colNmbr < colCount
      PrintOut "<td>&nbsp;</td>"
      colNmbr ++
      if colNmbr = colCount
         PrintOut "</tr>"
   end while


--
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."