[ Re: [PHP-DB] Filling Drop-Down Box.]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



<SELECT name="student" title="Student list">

<OPTION value="">---------------</OPTION>
<?PHP
while ($row = mysql_fetch_array($result)) {
?>
<OPTION value="<?php echo $row[3]?>" title="Select student <?php echo $row[1]," ", $row[2]?>"> <?php echo $row[3]?></OPTION>
<?php
}
?>
</SELECT>
In this case I've assumed that you'll have in mysql the following table:
row0: id (autoincrement)
row1: Nick name
row2: First name
row3: Last name


You can modify the code as you wish to get what you need.

Alexandru Mihai


Bastien Koert wrote:

i suggest you google for this...there are a million examples of this kind of code

bastien

From: Nayyar Ahmed <nayyares@xxxxxxxxx>
Reply-To: Nayyar Ahmed <nayyares@xxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject:  Filling Drop-Down Box.
Date: Sat, 25 Dec 2004 20:18:05 +0500

Hello All,

I want to fill drop-down box from mysql table, if any body
be kind to tell me a sample code :)
e.g:
In my application i want to gather subject list from current
semester-subject table of a student.

TIA
--
Nayyar Ahmad

Lecturer
Faculty Of Computer Science,
Institute Of Management Sciences,
Hayat Abad Peshawar , Pakistan.
Office : 92-091-9217404 , 9217452
Cell     :  92-0333-9139461

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux