kelvinfoo89

Hi Guys, i have a question regarding to create a php dynamic matrix table from survey form The table is for comparison purpose. I have a database that keep all the survey question, the feedback from employee. So let me show you the data in my database. Name questionID Question Answer -------------------------------------------------------------------- Foo 1000 How are you? I'm Fine Foo 1000 What's Your name? My Name is Foo Ben 1000 How are you? I'm Feel sick Ben 1000 How are you? My name is Ben Code that i Currently use: <table> <th>Question</th> <?php $curr_rows = 1; if (sqlsrv_num_rows($stmt) > 0) { while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) { echo "<tr>"; echo '<td name="question[' . $row["questionID"] . ']">' . $row['question'] . '</td>'; $curr_rows++; echo "</tr>"; } } else { echo "0 results"; } ?> <?php while ($row = sqlsrv_fetch_array($stmt2, SQLSRV_FETCH_ASSOC)) { echo '<th name="question[' . $row["questionID"] . ']">' . $row['Employee_Name'] . '</th>'; echo "<tr>"; echo '<td name="question[' . $row["questionID"] . ']">' . $row['answer'] . '</td>'; $curr_rows++; echo "</tr>"; $curr_rows++; } ?> </table> The Output that i expect is: Question Foo Ben -------------------------------------------------------------------------- How are you? I'm Fine I'm Feel sick What's Your name? My Name is Foo My name is Ben Please Help, I really need solution. Thank You