Loading data from database in drop down list-PLS HELP
Posted: Fri Dec 02, 2011 3:32 pm
Hello everyone. Can someone help me with this code, it doesn't work?
HTML CODE
PHP CODE

HTML CODE
Code: Select all
<table>
<tr>
<th>Ime korisnika:</th>
<td>
<select name="maticni_broj">
<OPTION VALUE=0>Choose
<?=$options_korisnik?>
</select>
<th>Naslov knjige:</th>
<td>
<select name="broj_knjige">
<OPTION VALUE=0>Choose
<?=$options_knjige?>
</select>
<td colspan="2" align="center">
<input type="submit" value=" Iznajmi ">
</td>
</tr>
</table>[/color]Code: Select all
<?php
$sql1="SELECT broj_knjige,naslov FROM knjige";
$result1=mysql_query($sql1);
$options_knjige="";
while ($row1=mysql_fetch_array($result1)) {
$broj_knjige=$row1["broj_knjige"];
$naslov=$row1["naslov"];
echo "<OPTION VALUE=\"$broj_knjige\">$naslov</option>\n";
}
$sql="SELECT maticni_broj,ime, prezime FROM clanovi";
$result=mysql_query($sql);
$options_korisnik="";
while ($row=mysql_fetch_array($result)) {
$maticni_broj=$row["maticni_broj"];
$ime=$row["ime"];
$prezime=$row["prezime"];
$options_korisnik.="<OPTION VALUE=\"$maticni_broj\">" .$ime .$prezime;
}
?>