Create PHP table grid help, please

Posted on 16th Feb 2014 by admin

I have a MySQL database setup, now it's time for the table (gridview) design in php. Here's the problem i'm having. I have about 22 colms, but from colm 10 to 16 I want to place in one colm from 1 up to 6 rows. 10 through 16 are allegation. Can someone make a simple php table so that I can learn from the source code. The only problem I have is understanding how to get (if) only 1 allegation is inputed into the database, compare to if 2 or 3 or 4 or 5 or 6 allegation will fit into only colm. Here are my headers

Officer
Date
LastName
FirstName
SID#
InstantOffense
DischargeDate
ArrestDate
Booking#
Allegation1, Allegation2, Allegation3, Allegation4, Allegation5, Allegation6
Type
CourtDate
InterviewDate
HearingDate
HearingType
BoardDate
BoardDecesion

As you can tell there are 6 type of allegation, there might and might now be up to 6 allegation, but how would i do a php table like this? I do have a simple HTML table at http://tdcj.homeip.net if you would like to view what i'm talking about..

Other forums