PHP Code:
<table border="1" cellspacing="1" cellpadding="5">
<tr>
<th>Questions</th>
<th>Your Answer</th>
<?php
foreach($closest as $key => $value){
$sql_name = mysql_query("SELECT * FROM candidates where id ='$key'");
$name[] = mysql_fetch_assoc($sql_name);
}
foreach($name as $key => $value){
echo "<th>".$value['name']."</th>";
}
?>
</tr>
<?php
$sql_question = mysql_query("SELECT * FROM questions");
while($row = mysql_fetch_assoc($sql_question)){
echo "<tr>";
echo "<td>".$row['question']."<td>";
echo "</tr>";
}
foreach($user_answer as $key => $value){
foreach($value as $answer){
echo "<tr>";
echo "<td>".$answer."</td>";
echo "</tr>";
}
}
?>
</table>
How can I build my table on the following patten.
HTML Code:
<table border="1" cellspacing="" cellpadding="5">
<tr>
<th>Questions</th>
<th>Your Answer</th>
<th>Obama</th>
<th>Clinton</th>
<th>Cox</th>
</tr>
<tr>
<td>Are you for or against drilling for energy and oil</td>
<td>For</td>
<td>Against</td>
<td>For</td>
<td>For</td>
</tr>
<tr>
<td>Are you for or against Embyronic Stem Cells</td>
<td>For</td>
<td>For</td>
<td>For</td>
<td>For</td>
</tr>
<tr>
<td>Are you for or against death penatly</td>
<td>Against</td>
<td>Against</td>
<td>For</td>
<td>Against</td>
</tr>
<tr>
<td>Are you for or against education for all childrens</td>
<td>Against</td>
<td>Against</td>
<td>Against</td>
<td>Against</td>
</tr>
<tr>
<td>Are you for or against same-sex marriage</td>
<td>For</td>
<td>Against</td>
<td>Against</td>
<td>For</td>
</tr>
</table>
$closest =
PHP Code:
Array
(
[4] => 2
[3] => 2
[2] => 2
)
$name =
PHP Code:
Array
(
[0] => Array
(
[id] => 4
[name] => Brownback
)
[1] => Array
(
[id] => 3
[name] => Biden
)
[2] => Array
(
[id] => 2
[name] => Clinton
)
)
$user_answer =
PHP Code:
Array
(
[0] => Array
(
[0] => 1
[1] => 2
[2] => 2
[3] => 1
[4] => 2
)
)
I want to base the table on the HTML above but I cannot create it. How would I go about doing it?