<?php
$trainer = $_POST['reportname'];
$workshop = $_POST['workshopname'];
$con = mysql_connect("localhost", "admin", "");
if (!$con) {
die('Not connected : ' . mysql_error());
}
mysql_select_db("evaluationform",$con);
$report = mysql_query("SELECT * FROM evaluation where trainer like '$trainer%'and workshop like '$workshop'ORDER BY q1");
if (!$report)
{
echo("<b>Error performing query: " . mysql_error() . "</b>");
exit();
}
print " |q1 | q2 | q3 | q4 | q5
| q6 | q7 | q8 | q9
| q10 | q11| q12| q13";
/*here is my problem question 1-11 are just numbers so they fit fine in this schema however, question 12 and 13 and textboxes therefore when people write more than a couple of characters the whole table get mess up. What I need is some way to display the data in a very elagant fashion. I been experimenting with while statements and tables but is quite difficult I just need some hints and examples if at all possible. */
while ($row = mysql_fetch_array($report))
{
$question1 = $row["q1"];
$question2 = $row["q2"];
$question3 = $row["q3"];
$question4 = $row["q4"];
$question5 = $row["q5"];
$question6 = $row["q6"];
$question7 = $row["q7"];
$question8 = $row["q8"];
$question9 =$row["q9"];
$question10 =$row["q10"];
$question11 =$row["q11"];
$question12 =$row["q12"];
$question13 =$row["q13"];
print("
<table>
<tr>
<td> $question1 </td>
<td> $question2 </td>
<td> $question3 </td>
<td> $question4 </td>
<td> $question5 </td>
<td> $question6 </td>
<td> $question7 </td>
<td> $question8 </td>
<td> $question9 </td>
<td> $question10 </td>
<td> $question11 </td>
<td> $question12 </td>
<td> $question13 </td>
</tr>
</table>");
}
print("<br><br>");
print("
<td> The evaluation of this trainer:$trainer</td><br>
<td> Regarding this workshop: $workshop</td>");
?>
