Present data and input in the database

yimma216

Hi,

I have a list of data need to put into mySQL and present them in a webpage.
How could I presnet the attached data sheet?

The top title is the item_no. First column is the size. Each item_no with the specific length size has a conductor size. But not every item has a length size and/or conductor size.

Many Thanks.

Dormilich

Quote:

Originally Posted by yimma216

But not every item has a length size and/or conductor size.

then use a reasonable default value (like 0 or NULL)

Atli

Hey.

What about a MySQL table like this?

Expand|Select|Wrap|Line Numbers

 +--------+--------+------+------+

| ItemNO | Length | CMin | CMax |

+--------+--------+------+------+

| RD5545 | 32.5   | 0    | 14   |

| RD5545 | 45     | 0    | 32   |

| RD5560 | 45     | 0    | 18   |

| RD5560 | 55     | 0    | 38   |

| RD5575 | 55     | 0    | 28   |

+--------+--------+------+------+

There is no need to list ItemNo/Size combos that have no value. You would just add them to the list later on if they are needed.

As for displaying the table, the spreadsheet-like format in your image is easily replicated in HTML with a simple HTML table.

yimma216

Thank both of you. I will try to work on your sample, Atli.

Present data and input in the database

re: Present data and input in the database

re: Present data and input in the database

re: Present data and input in the database

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about