display my database in an array

knightneo · December 2nd, 2006, 01:33 AM

my database usersdb has a table named users and is made up of id, username and password i only need to display the username in an array, so that i can select them individually... thnx...

knightneo · December 2nd, 2006, 01:51 AM

this is my html code and i want to insert a array box after the Access the time-in/time-out table for user
using php code, just like my previous post i only want to display in an array box the content of my table named users but only the username.

here's the html code:

<html>
<head>
</head>
<body>
<h3>USER'S MANAGEMENT</h3>
<input name="radiobutton" value="rb8" type="radio">
<b>Add/Delete/Modify password of users</b>
<br>
<br>
<input name="radiobutton" value="rb9" type="radio">
<b>Access the time-in/time-out table for user</b>
<br>
<br>
<input value="Manage User's" type="submit">
</body>
</html>

where should i insert my php script?

akremedy · December 3rd, 2006, 01:25 AM

It sounds like you want to construct a combo box/select field/etc that the user can click to drop down a list of users to select from - is that right?

How about something like this between the <br> tags after "Access the time..."?
<?
echo "<select>\n";
  $query = "SELECT username FROM users ORDER BY username ASC";
  $res = @mysql_query($query);
  while($row = mysql_fetch_array($res)) {
    printf("<option value=\"$row[username]\">$row[username]</option>\n");
  }
  mysql-free_result($res);
echo "</select>";
?>

I've assumed that you're connecting to the database somewhere above the opening <html> tag. If that's not a safe assumption, you might want to include something like this above <html>:

<?
$sql = mysql_connect(localhost, <db_user>, <password>);
@mysql_select_db(usersdb, $sql);
?>

Hope that helps.