Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: HTML PHP MySQL Help
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:
$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
but i cant figure it onto the
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 Big Grin | :-D
Posted 25-Apr-13 5:26am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

mysql_connect('****', '****', '****');
$sql = "SELECT kid FROM Kcode WHERE lid='".$_SESSION['lid']."' AND sid='".$_SESSION['id']."'";
$result = mysql_query($sql);
echo "&<select style="margin-top:-1px;" name="kid">";
echo "<option>Vælg klasse<option>";
while ($row = mysql_fetch_array($result)) {
echo "<option value="" . $row[" kid="] . "">" . $row['kid'] . "</option>";
echo "</option></option></option></select>";
basicly i stripped it from mysqli and converte it to normal mysql

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

Advertise | Privacy | Mobile
Web03 | 2.8.150327.1 | Last Updated 25 Apr 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100