hi
how to polute my drop down using the database content...........
lydia21 9 Junior Poster
nav33n 472 Purple hazed! Team Colleague Featured Poster
polute ? What do you mean by that ?
tirivamwe 1 Light Poster
try this code it works for me
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="forum"; // Database name
$tbl_name="test_mysql"; // Table name
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM test_mysql";
$result=mysql_query($sql);
?>
<form name="form1" method="post" action="">
<select name="Names" id="Names">
<?php
while($rows=mysql_fetch_array($result, MYSQL_ASSOC))
{
echo"<option>". $rows['name']."</option>"; //to display names from database in field called name
}
mysql_close();
?>
</select>
</form> nav33n commented: Thanks for the rep man. I am not good enough though. I m still learning. +1
lydia21 9 Junior Poster
sorry how to retrieve the table content and display in a dropdown
tirivamwe 1 Light Poster
can you please be specific.
Do you want to put content from database into drop down or from a table. If from a table where is the content coming from
lydia21 9 Junior Poster
thanks
nav33n 472 Purple hazed! Team Colleague Featured Poster
You can do something like tirivamwe has mentioned. Or you can use a function so that you can reuse the code whenever you want.
<?php
$conn=mysql_connect("localhost","root");
mysql_select_db("test");
function dropdown($colname,$tablename){
$query="select ".$colname." from ".$tablename;
$result=mysql_query($query);
$option="";
while($row=mysql_fetch_array($result)){
$option.="<option value=".$row[0].">".$row[0]."</option>";
}
return $option;
}
?>
<html>
<body>
<form>
<select name='test'>
<?php echo $options=dropdown("Column_name","Table_name");
//the column name of table_name which you want to display in the options
?>
</select>
<select name='test1'>
<?php echo $options=dropdown("Column_name1","Table_name2");
?>
</select>
</form>
</body>
</html> lydia21 9 Junior Poster
hi
this works but how to get the dropwown value in the next page..
i tried with $id=$_REQUEST; but this is not working
<form method="get" action="sort2.php">
<?php
$hostname = "localhost";
$username = "";
$password = "";
$dbid = "";
$link=mysql_connect($hostname, $username, $password);
mysql_select_db($dbid) or die("unable to connect");
$sql="SELECT id,name FROM personal";
$result=mysql_query($sql);
?>
<table>
<tr>
<td>Splendor Id</td><td><select name="Names">
<?php
while($rows=mysql_fetch_array($result))
{
echo"<option value=".$rows[0].">". $rows[1]."</option>";
}
mysql_close();
?>
</select></td>
</tr>
<tr>
<td>From</td><td><input type="text" name="from"></td>
<td>To</td><td><input type="text" name="to"></td>
<td><input type="submit" name="submit" value="submit"></td></tr>
</table>
</form>
nav33n 472 Purple hazed! Team Colleague Featured Poster
hi
this works but how to get the dropwown value in the next page..
i tried with $id=$_REQUEST; but this is not working
<form method="get" action="sort2.php">
<?php
$hostname = "localhost";
$username = "";
$password = "";
$dbid = "";
$link=mysql_connect($hostname, $username, $password);
mysql_select_db($dbid) or die("unable to connect");$sql="SELECT id,name FROM personal";
$result=mysql_query($sql);?>
<table><tr>
<td>Splendor Id</td><td><select name="Names">
<?phpwhile($rows=mysql_fetch_array($result))
{
echo"<option value=".$rows[0].">". $rows[1]."</option>";
}mysql_close();
?>
</select></td>
</tr>
<tr>
<td>From</td><td><input type="text" name="from"></td>
<td>To</td><td><input type="text" name="to"></td>
<td><input type="submit" name="submit" value="submit"></td></tr></table>
</form>
$id=$_REQUEST should be $id=$_REQUEST
And Please, next time you post your code, place it within [ code] ... [ / code] tags !
lydia21 9 Junior Poster
sorry.......
thanks
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.