How to retrieve from table and put it in List Box?

[miha]

I would like to do it with code and retrieve e-mail which is in table users.

<SELECT NAME="email">
                <?php
                    $users = mysql_table("SELECT * FROM users ORDER BY fname", $db);
                    foreach(...)
                                               {

                    }

            ?> 

Table USERS has fields index (autoincremented), username, email

[bpat1434]

umm.... read up on [man]mysql_query/man and [man]mysql_fetch_array/man...
Then use a [man]while/man loop to go through each row, and create your listbox as you want.

~Brett

[miha]

How to do it with
<SELECT NAME="email">
<?php
$users = mysql_table("SELECT * FROM users ORDER BY fname", $db);
foreach(...AS...)
{

                    }

            ?>

Table USERS has fields index (autoincremented), username, email

[bpat1434]

echo '<select name="email">';
$rslt = mysql_query("SELECT * FROM users ORDER BY fname");
while($row = mysql_fetch_array($rslt))
{
  echo '<option value="'.$row['email'].'">'.$row['username'].'</option>';
}
echo '</select>';

~Brett

[miha]

Thanks
If I understand it will have List Box names with usernames but value posted ($_POST)
email?

How can I connect to db?
Is O.K with : while($row = mysql_fetch_array($rslt, $db))

[bpat1434]

Read the manual... all your questions will be answered if you just take time and read: [man]mysql[/man]. There's a list of mySQL functions you can use, plus how to use them, and what they return.

~Brett

[miha]

thanks I have done with while code