Selecting a course name

Hey fellow programmers,

It's 12:50 in the AM and i'm still up, battling with my project...

A quick one: I'm trying to include a "Multiline List Box", something like a drop-down list, for the "Course name" area of the student_reg.php page.

Here's my code:

Language: PHP
<td>
				Course name:
				</td>
				<td >
				<select name="courses" style=width:"150px">
					<option value="" selected>Select a course...</option>
				//================================
				//SELECT LIST OF COURSES AVAILABLE
				//================================	
				<?php
				$query = "SELECT * FROM course";
				$result = mysql_query($query) or die (mysql_error());
 
				while ($row = mysql_fetch_array($result)){
 
				echo "<option value=" . $row[';cname';] . ">";
				echo "</option>"; 
 
				}
				?>
 
				</select>

It's working fine except that the courses are not showing. It's printing out the rows but the names are not visible.

What could be wrong in the code?

Thanks in anticipation...

78026962 afojonny

The name must be echoed between the option tags....

Try something like this:

Language: PHP
$sql = "SELECT cid, cname FROM course ORDER BY cname ASC";
		$selResult = mysql_query($sql);
		echo"<option value = ';0';>Select Course</option>";
			while($selRows = mysql_fetch_array($selResult)){
				$id = htmlspecialchars($selRows["cid"])	;
				$course = htmlspecialchars($selRows["cname"]);
				echo "<option value=';$id';>$course</option>";
			}

Thanks mac!

Thanks AlexB...it worked perfectly well. By the way, why do i need to format $id and $course with the htmlspecialchar?

78026962 afojonny

I read on one of the PHP forums that this will also help secure data coming from the outside of your site. You can use it without the htmlspecialchar, I did it as a test to see what happens.



afojonny Wrote:
-------------------------------------------------------
> Thanks mac!
>
> Thanks AlexB...it worked perfectly well. By the
> way, why do i need to format $id and $course with
> the htmlspecialchar?

Awesome stuff! Thanks again AlexB.

78026962 afojonny