PHP Drop Down Data from Database

Question

I am trying to make an select field for data according to my database. So, basically, I want it to have a dropdown menu for all the users in my database. So like instead of doing:

<select>
  <option>1st User in Db</option>
  <option>2nd User in Db</option>
</select>

It just automatically shows all.

I tried fetching a $row['uname'], and setting it as $user, but then it only shows MY user in the dropdown.

Example: http://prntscr.com/dwksy

It only shows my account, admin, instead of all the other ones. Anyone know how to do this? Thanks!

Can we see the SQL you're using to query the database? And the PHP generating the list? — andrewsi
– andrewsi, Commented Aug 16, 2012 at 20:17
Sounds like you need a different query to get the right info back. — j08691
– j08691, Commented Aug 16, 2012 at 20:17

andrewsi · Accepted Answer · 2012-08-16 20:55:54Z

1

<?php

session_start();
include 'config.php';
$user = $_SESSION['username'];
$qry=("SELECT `rank`, `uname` FROM users WHERE uname='$user'");
$result=mysql_query($qry);
$row = mysql_fetch_assoc($result);
$rank = $row["rank"]

if ($_SESSION['loggedin'] == true) {
    if ($rank >= 3) {
        $qry=("SELECT `rank`, `uname` FROM users");
        $result=mysql_query($qry);

        echo "
        <form action='' method='POST'>
        <select>";

        while ($row = mysql_fetch_assoc($result)) {
            $rank = $row['rank'];
            $users = $row['uname'];
            $lol = ucwords($users);

            echo "<option>$lol</option>";
        }

        echo "</select>
        </form>
        ";
      } else {
          echo "Your level is not 3, but you are logged in.";
      }
  } else {
     echo "Please login.";
  }

edited Aug 16, 2012 at 20:55

answered Aug 16, 2012 at 20:21

andrewsi

10.7k132 gold badges37 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

13 Comments

user1604290 Over a year ago

Okay, now it is getting tangled with my if statements

andrewsi Over a year ago

Do you want to add them to the question?

user1604290 Over a year ago

Added !! :) This has to be atleast 15 chars so iosfjeorjferf

andrewsi Over a year ago

I think that should do it. There are a few things you should look at, though, like making sure your query is returning data; and you might want to look into converting it to use PDO, too.

user1604290 Over a year ago

That's the code that doesn't work and only shows MY user. I want it to show every user in the database. Can you fix up my code? When I add the wait loop, it just gives me unexpected T_ELSE, because it gets tangled with my other codes.

|

alexis · Accepted Answer · 2012-08-16 20:30:55Z

1

Your query only fetches the user recorded in $_SESSION. Drop the WHERE clause to get all users in the result, then read them with @andrewsi's loop and spit out one <option> for each user returned:

$qry=("SELECT `rank`, `uname` FROM users");

edited Aug 16, 2012 at 20:30

answered Aug 16, 2012 at 20:25

alexis

50.4k18 gold badges107 silver badges172 bronze badges

Collectives™ on Stack Overflow

PHP Drop Down Data from Database

2 Answers 2

13 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

13 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related