Table format

[scvinodkumar]

Hi i have a table contains information for different categories,

 

category_id information

1              test1,test1.1,test1.2

2              test2,test2.1,test2.2

3              test3,test3.1,test3.2

....

 

Now, i want to display this like this,

 

1          2          3

test1    test2    test3

test1.1  test2.1  test3.1

test1.2  test2.2  test3.2

...        ..

.

.

.

 

so the first row contains category name and from second rows it contains information.

 

How to bring this format in php?

 

[jjacquay712]

Hope this helps:

 

<table>
<?php
$query = mysql_query("SELECT * FROM table;");

$number_of_results = mysql_num_rows($query);

echo "<tr>";
for ( $n = 1; $n <= $number_of_results; $n++ ) { // Loop through the number of results and make a table row with the index
     echo "<td>" . $n . "</td>";
}
echo "</tr>";

echo "<tr>";
while ( $result = mysql_fetch_array($query) ) {
       echo "<td>" . $result['information'] . "</td>"; // Loop through the database results and put it into a table row
}
echo "</tr>";
?>
</table>