Hello Alex:
It is really helpfull, :)
thanks for your detailed reply
regards,
On Sat, 25 Dec 2004 23:57:51 +0200, Alexandru Mihai <alexmihai@xxxxxxx> wrote:
> <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
>
>
--
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
