使用rowspan将数据从数据库调用到表中

Question

I have table "Owner" in my database where one of the field (System) saved data from a textarea box.

Table Owner;

staf_id || name || system

Below is an example of input of the textarea box;

aimsweb
elearning
registration

The example shows that each line represent different types system. How am I going to call data from the system field to the table below?

table http://img546.imageshack.us/img546/1170/31920845.png

When it is called, the columns "Staf ID" and "Name" will increase its rowspan based on the input in the textarea. Is it possible to do that?

Answer 1

In php you could use:

$rows_in_text_area = explode( "
", $system );

Which should give you the number of rows of text in the text area. From there it should be straight forward to use the $rows_in_text_area for the rowspan in the staff ID and name cells like this:

<td rowspan="$rows_in_text_area">$name</td>