Create PHP table grid help, please

[tinkertron]

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...

[nafetski]

So you want one database field to house multiple variables?

 

Low and behold

 

http://php.net/manual/en/function.serialize.php

 

 

[greatstar00]

well, when u using mysql query, u can do string concatenation

SELECT

Officer,

Date,

LastName,

FirstName,

SID,

InstantOffense,

DischargeDate,

ArrestDate,

Booking,

concat(Allegation1, Allegation2, Allegation3, Allegation4, Allegation5, Allegation6) as Allegation,

Type,

CourtDate,

InterviewDate,

HearingDate,

HearingType,

BoardDate,

BoardDecesion FROM table1

 

NOTE, u can put delimiters, in concat

like concat (str1, '|', str2, '|'...........)