Click here to Skip to main content
Rate this: bad
good
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
$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 Big Grin | :-D
Posted 25-Apr-13 5:26am

1 solution

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

Solution 1

mysql_connect('****', '****', '****');
mysql_select_db('*****');
 
$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
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 295
1 Maciej Los 280
2 Afzaal Ahmad Zeeshan 224
3 BillWoodruff 205
4 Sergey Alexandrovich Kryukov 195
0 OriginalGriff 6,499
1 Sergey Alexandrovich Kryukov 6,048
2 DamithSL 5,193
3 Manas Bhardwaj 4,657
4 Maciej Los 4,120


Advertise | Privacy | Mobile
Web04 | 2.8.1411019.1 | Last Updated 25 Apr 2013
Copyright © CodeProject, 1999-2014
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