i cant figure out how to make a mysql populated drop down menu

Question

0.00/5 (No votes)

See more:

hi there

ive been working for an hour on this drop down menu... but it seems not to populate it.

my code is a following:

PHP

$sql = "SELECT kid FROM Kcode";
				$result = $db->query($sql); 
				
				echo "<select name='kid'>";
				echo "<option value='" . $row['kid'] . "'>Choose class</option>";
				while ($row = mysql_fetch_array($result)) {
			 	echo "<option value='" . $row['kid'] . "'>" . $row['kid'] . "</option>";
}
				echo "</select>";

i know that i use a mysqli code for the

$db->query

but i cant figure it onto the

$row

ive tried for so long now and still havent figured out why im not able to get what i want.

hope u can help me :-D

Posted 25-Apr-13 4:26am

bertleren

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

bertleren · Accepted Answer · 2013-04-25T04:47:00

mysql_connect('****', '****', '****');
mysql_select_db('*****');

$sql = "SELECT kid FROM Kcode WHERE lid='".$_SESSION['lid']."' AND sid='".$_SESSION['id']."'";
$result = mysql_query($sql);

echo "&";
echo "Vælg klasse";
while ($row = mysql_fetch_array($result)) {
echo "" . $row['kid'] . "</option>";
}
echo "";

?>

basicly i stripped it from mysqli and converte it to normal mysql

i cant figure out how to make a mysql populated drop down menu

1 solution

Solution 1

Add your solution here

Preview 0

i cant figure out how to make a mysql populated drop down menu

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us