|
|
Posted by strawberry on 03/31/06 15:16
Here's how I do it...
The form:
echo "<select name='student'>\n";
echo "<option value=''>Select...\n";
while ($row = mysql_fetch_array ($students,MYSQL_ASSOC))
{
echo "<option value={$row['student_id']}>{$row['f_name']}
{$row['l_name']}\n";
}
echo "</select>\n";
The query that populates this list goes something like this. Apologies
for any errors:
//Get a list of all students (e.g. student_id,f_name,l_name) and order
them by last name.
//Put records with no last name at the bottom of the list.
$query = "SELECT * ,
IF(l_name IS NULL or l_name='', 1, 0)
AS isnull
FROM students
ORDER BY isnull ASC, l_name ASC;";
$students = mysql_query($query) or die ("Couldn't gather a list of
students!!!");
The trick is simply passing the student_id to the 'option value'
statement.
HTH
Navigation:
[Reply to this message]
|