Presenting queries in formlike manner

Tezread

I have a query that when it runs, simply lists a coursename and then all the details about that course. Trouble is the look of this query sucks.

You know in MS Access when you run a form design wizard and you can present a query by justifying it, putting it ib columns or a table? well Im am trying to justify it so it comes out looking like a form- how can I do this?

Here is my code so far:

<?php 
if (isset($_GET['course'])) { 
$user = "root"; 
$host = "localhost"; 
$password = ""; 
$connection = mysql_connect($host, $user, $password) or die ("Couldn't connect to server."); 
$database = "memlms"; 
$db = mysql_select_db($database) or die ("Couldn't select database."); 

$course = mysql_real_escape_string($_GET['course']); 
$res = "SELECT * FROM trainingtopics WHERE course_name = '$course'"; 
$result = mysql_query($res) or die(mysql_error()); 
if (mysql_num_rows($result) > 0) { 
while ($row = mysql_fetch_assoc($result)) { 

echo ' 
<tr> 
<td width="100%"><strong><p align="center" class="style4 style11"><td>' . $row['course_name'] .'</td></strong></p> 
<br>
<td width="79%"><strong><p align="left" class="style4 style11">Aimed at</strong></p>
<br>
<td>' . $row['aimedat'] . '</td> 
<br>
<td width="79%"><strong><p align="left" class="style4 style11">Level 1?</strong></p>
<br>
<td>' . $row['level1'] . '</td> 
<br>
<td width="79%"><strong><p align="left" class="style4 style11">Level 2?</strong></p>
<br>
<td>' . $row['level2'] . '</td>
<br>
<td width="79%"><strong><p align="left" class="style4 style11">Level 3?</strong></p>
<br>
<td>' . $row['level3'] . '</td> 
<br>
<td width="79%"><strong><p align="left" class="style4 style11">Available through e learning?</strong></p>
<br>
<td>' . $row['elearning'] . '</td> 
<br>
<td width="79%"><strong><p align="left" class="style4 style11">Availble through face to face classroom based training?</strong></p>
<br>
<td>' . $row['facetoface'] . '</td> 
<br>
<td width="79%"><strong><p align="left" class="style4 style11">Available through blended learning? (face to face and e learning)</strong></p>
<br>
<td>' . $row['blendedlearning'] . '</td>
<br> 
<td width="79%"><strong><p align="left" class="style4 style11">E learning study time</strong></p>
<br>
<td>' . $row['elearntime'] . '</td> 
<br>
<td width="79%"><strong><p align="left" class="style4 style11">Face to face learning study time</strong></p>
<br>
<td>' . $row['facetime'] . '</td>
<br>
<td width="79%"><strong><p align="left" class="style4 style11">Blended learning study time</strong></p>
<br>
<td>' . $row['blendedtime'] . '</td> 
<br>
</tr> 
';

} 

} else { 
//course name not found 
//note: the query may have failed to so maybe check for that. 
} 
} else { 
//no course specified 
} 
?>

Tezread

Im not sure if I came across as too vague in my original post. In basic terms I would like to present a query by justifying it like in MS Access. Don't know why I didn't say that before!

Rodney_H_

Well from your code, it looks like you have a handle on what you would like to do, by echoing the values from th DB into your table, formated however you wish in HTML.

I guess beyond that, I don't know if you have any other questions... Do you??

Tezread

I was looking to create a query that looks like this (see attached picture).

Rodney_H_

What you need is some good old CSS and HTML to design your table to be layed out and to look like you want. This isn't really a php question.

However, give something like this a try:

<?php 
/* < ---------------------- Your SQL query here --------------------- >  */


// begin output here:
echo '<style type="text/css">
#myTable td {
	font-family:arial, helvetica, sans-serif;
	font-size: 12px;
	}
.heading {
	background:#eee;
	color: #0000cc;
	}
</style>
<table cellpadding="2" cellspacing="0" border="1" id="myTable" width="500px">
<tr>
<td class="heading" colspan="3">Course Name</td>
</tr>
<tr>
<td colspan="3">' . $row['course_name'] .'</td>
</tr>
<tr>
<td class="heading" colspan="3">Aimed at</td>
</tr>
<tr>
<td colspan="3">' . $row['aimedat'] . '
<br />&nbsp;</td>
</tr>
<tr>
<td class="heading">Level 1</td> 
<td class="heading">Level 2</td>
<td class="heading">Level 3</td>
</tr>
<tr>
<td>' . $row['level1'] . '</td>
<td>' . $row['level2'] . '</td>
<td>' . $row['level3'] . '</td>
</tr>
<tr>
<td class="heading">E learning?</td>
<td class="heading">Face to Face</td>
<td class="heading">Blended</td>
</tr>
<tr>
<td>' . $row['elearning'] . '</td>
<td>' . $row['facetoface'] . '</td>
<td>' . $row['blendedlearning'] . '</td>
</tr>
<tr>
<td class="heading">E learning study time</td>
<td class="heading">Face to face learning study time</td>
<td class="heading">Blended learning study time</td>
</tr>
<tr>
<td>' . $row['elearntime'] . '</td>
<td>' . $row['facetime'] . '</td>
<td>' . $row['blendedtime'] . '</td>
</tr>
<tr>
<td class="heading" colspan="3">Course Aims</td>
</tr>
<tr>
<td colspan="3">To become clever
<br />&nbsp;</td>
</tr>
<tr>
<td class="heading" colspan="3">Course Outcomes</td>
</tr>
<tr>
<td colspan="3">To earn a diploma
<br />&nbsp;</td>
</tr>
</table>';

?>