Notice: Undefined index: DISTRICT in..................

billy1

I'm not sure what the issue is. Any ideas?

CODE:

Build Second menu.

if (array_key_exists("SELECT_RSB", $GET)) {
$rsb = $GET["SELECT_RSB"];

$result = mssql_query("SELECT DISTINCT District FROM tblSections WHERE rsb  = '$rsb'");

?>
<tr>
<td>
<select name='SELECT_DISTRICT'>

<?
while ($district = mssql_fetch_array($result)) {

?>
<option value='<?$district["DISTRICT"]?>'>
<?$district["DISTRICT"]?>
</option>
<?
}
?>

?>
</select>

bradgrafelman

Probably that the field is Distrct and you're trying to get DISTRICT.

Not to mention that this:

<?$district["DISTRICT"]?>

doesn't do anything anyway. It should be written like so:

$<?PHP echo $district["DISTRICT"]; ?>

dcav

Trying using mssql_fetch_assoc instead.

I never used fetch_array but I'm guessing fetch_array would produce a [0] first. Like: [0]->["District"]Thus, you're array inquiry is indeed undefined.

Houdini

bradgrafelman wrote:
Probably that the field is Distrct and you're trying to get DISTRICT.

Not to mention that this:
<?$district["DISTRICT"]?>
doesn't do anything anyway. It should be written like so:
$<?PHP echo $district["DISTRICT"]; ?>

Is correct it has nothing to do with mysql_fetch_array() or mysql_fetch_assoc() see this: Source:PHP Manual:mysql_fetch_assoc()

Description
array mysql_fetch_assoc ( resource result )

Returns an associative array that corresponds to the fetched row and moves the internal data pointer ahead. mysql_fetch_assoc() is equivalent to calling mysql_fetch_array() with MYSQL_ASSOC for the optional second parameter. It only returns an associative array.