Dropdown fra mysql
Snoeft fandt noget men det virker ikke,Viser bare:
".$folder; } ?> og formen uden der er noget i dropdown
Nogen der kan hjaelpe
Code:
<html>
<body>
<?
$con = mysql_connect("host","database","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("awc24h_links", $con);
$sql="SELECT id, folder FROM users";
$result=mysql_query($sql);
$options="";
while ($row=mysql_fetch_array($result)) {
$id=$row["id"];
$folder=$row["folder"];
$options.="<OPTION VALUE=\"$id\">".$folder;
}
?>
<form action="insert.php" method="post">
<div>
<table border="0">
<tr>
<td></td><td><input type="hidden" value="http://awc24h.com/click" name="link1" /></td></tr>
<tr>
<td>Link part2:</td><td><input type="text" name="link2" /></td></tr>
<tr>
<td>Folder:</td><td><SELECT NAME=folder>
<OPTION VALUE=0>Choose
<?=$options?>
</SELECT></td></tr>
<tr>
<td></td><td><input type="submit" value="Post"/></td></tr>
</form>
</body>
</html>
Viser bare:
".$folder; } ?> og formen uden der er noget i dropdown