retreiving data in drop down from database

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
yasir_memon
Forum Commoner
Posts: 48
Joined: Tue Aug 11, 2009 12:29 am

retreiving data in drop down from database

Post by yasir_memon »

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
User avatar
aceconcepts
DevNet Resident
Posts: 1424
Joined: Mon Feb 06, 2006 11:26 am
Location: London

Re: retreiving data in drop down from database

Post by aceconcepts »

This is one approach:

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);
 
I haven't tested it but that's it :D
yasir_memon
Forum Commoner
Posts: 48
Joined: Tue Aug 11, 2009 12:29 am

Re: retreiving data in drop down from database

Post by yasir_memon »

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.
User avatar
juma929
Forum Commoner
Posts: 72
Joined: Wed Jun 17, 2009 9:41 am

Re: retreiving data in drop down from database

Post by juma929 »

Hello,

Did you just run that code or did you adjust it to match your specific requirements yasir_memon?

:dubious:
yasir_memon
Forum Commoner
Posts: 48
Joined: Tue Aug 11, 2009 12:29 am

Re: retreiving data in drop down from database

Post by yasir_memon »

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>';
Post Reply