Populating drop down menu in a form??

sschatz

I am having problems getting a select field to be populated from a database entry.

The drop down menu has blanks for each of the entrys in the database, but there is no data actually printed in those blanks.

Here is the code I have :

	
<?
include ( "db_odbc.inc" );
include ( "db_odbc.inc" );
class ActionItem extends DB_Sql
{
var $Database	= "localdsn";
var $User		= "user";
var $Password	= "pwd";
}
function GetGenOpts ( $aTableName, $aCurSel = "" )
{
$aResult = "";
$aDB = new ActionItem;
$aSQL = "select issue_num from $aTableName order by issue_num";
$aDB->query( $aSQL );
while( $aDB->next_record() )
{	
$aName	= $aDB->f( "issue_num" );
if ($aName == $aCurSel )
{
$aResult .= "<option value=\"$aName\" selected>$aName</option>";
}
else
{
$aResult .= "<option value=\"$aName\">$aName</option>";
}
}
return $aResult;
}
?>
<form name="form1" action="somwhere.php" method="post">
<table width="750" border="0" cellspacing="2" cellpadding="2">
<tr valign="top"> 
<td>Issue Number :</td>
<td>
<select name="select">
<?php
print( GetGenOpts( "issue", "issue_num" ) );
?>
</select>
</td>
</tr>
<tr valign="top">
<td>
<input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</form>

Any help would be greatly appreciated.

Thanks!

-Steve

PHP-Editors_com

it's hard to tell without seing all the code (full database classes), but one thing sticks out - you have 2 include files at the top of your script that are the same!! this seems a little strange.

sschatz

actually the duplicate include was just a cut and paste error, i noticed it after i posted.

do you need to see what is in the include file? sorry, i am kind of new to this...

thanks!

run_GMoney

I'm a little confused by the values being passed to the GetGenOpts function. You've got two values ($aTableName and $aCurSel = " "). I'm not familiar with this method of variable passing. What happens when you try to send a variable to the $aCurSel = " " value in the function? That just seems a little odd to me but then again i'm pretty new to this as well.

arciess

Try adding echo's into each if/else to trace where your logic is going. like:

if ($aName == $aCurSel )
{
$aResult .= "<option value=\"$aName\" selected>$aName</option>";
echo("item: ".$aName." - selected<BR>");
}
else
{
$aResult .= "<option value=\"$aName\">$aName</option>";
echo("item: ".$aName."<BR>");
}

Then make sure the value is still set... start narrowing it down. I dont know that DB class very well so its hard to see if you are unsetting the values somewhere.

hope it helps, -rs

saidbakr

Hi,
I'd like to remeber you, to make things more easy, PHP script can be separted inside the file by ordinary HTML tags and all will go fine, look for this example

<?
for ($i = 1; $i <= 10; ++$i):
?>
<b>Hello variable No</b> <?=$i?>
<?
endfor;
?>

this will give print out as:
Hello variable No 1
Hello variable No 2
Hello variable No 3
Hello variable No 4
......
Hello variable No 10.

By applying this, it will be so easy to deal with HTML elements inside your script without in difficulties with ' or " or echo, etc
I hope this offer a help