i want to show the department names stored in database into drop down can any one please send me the php coding for that
thanks
retreiving data in drop down from database
Moderator: General Moderators
-
yasir_memon
- Forum Commoner
- Posts: 48
- Joined: Tue Aug 11, 2009 12:29 am
- aceconcepts
- DevNet Resident
- Posts: 1424
- Joined: Mon Feb 06, 2006 11:26 am
- Location: London
Re: retreiving data in drop down from database
This is one approach:
I haven't tested it but that's it 
Code: Select all
//setup your query
$query = mysql_query("SELECT dept FROM tblDepartment ORDER BY dept");
//open your drop down list
echo '<select name="deptList">';
//initialise a loop of the query results
while($row = mysql_fetch_array($query))
{
//output you drop down list content
echo '<option value="'.$row['dept'].'">'.$row['dept'].'</option>';
}
//close your drop down list
echo '</select>';
mysql_free_result($query);
-
yasir_memon
- Forum Commoner
- Posts: 48
- Joined: Tue Aug 11, 2009 12:29 am
Re: retreiving data in drop down from database
this code is not working properly their is no thing in drop down after using this code can any u please send me tested code for that.
Re: retreiving data in drop down from database
Hello,
Did you just run that code or did you adjust it to match your specific requirements yasir_memon?

Did you just run that code or did you adjust it to match your specific requirements yasir_memon?
-
yasir_memon
- Forum Commoner
- Posts: 48
- Joined: Tue Aug 11, 2009 12:29 am
Re: retreiving data in drop down from database
ofcourse dear i used this code
$conn=odbc_connect('AKTMAPP','ERP_TEST','ERP_TEST');
$sql="select dept_name from departmentfile order by dept_name";
$rs=odbc_exec($conn,$sql);
echo '<select name="dddept">';
while($row = odbc_fetch_array($rs))
{
echo '<option value="'.$row['dept_name'].'">'.$row['dept_name'].'</option>';
}
echo '</select>';
$conn=odbc_connect('AKTMAPP','ERP_TEST','ERP_TEST');
$sql="select dept_name from departmentfile order by dept_name";
$rs=odbc_exec($conn,$sql);
echo '<select name="dddept">';
while($row = odbc_fetch_array($rs))
{
echo '<option value="'.$row['dept_name'].'">'.$row['dept_name'].'</option>';
}
echo '</select>';