[Resolved] list box help

it_is_spatial

I've got a list box accessing an MS SQL database. The trouble that i'm having is that the 'NAME' field shows in my listbox but when I alert for the 'LEA' field that should be set in the value of the option it is blank. The code below will make things a little more clear. Basically i'm needing the 'NAME' field to show but the 'LEA' field to be passed. Any help would be great.

$db_connect = mssql_connect('FWM-Data', 'tmp_PHP', '!qsplwd12'); 
mssql_select_db('master', $db_connect); 
$query1 = "SELECT DISTINCT(NAME) FROM School_Districts"; 
$result1 = mssql_query($query1);
print "<form name=choose_campus action=".$_SERVER['PHP_SELF']." method=post>";
print "<P align=center><select name=school_dist onchange=goDistrict()>";
while($district = mssql_fetch_array($result1)){ 
    print "<option value=".$district['LEA'].">".$district['NAME']."</option>";

} //end while
print "<option value=\"\" selected> --Select a District-- </option>";

gufmn

Close your select tag:

it_is_spatial

Thanks for catchin that. it is still populating the pulldown with the 'NAME' field but still nothing in the value of the select. I can't see what's wrong. If its grabbing the 'NAME' field why wouldn't it be getting the 'LEA' field as well?

gufmn

When you run this, What does the html source look like?

it_is_spatial

Looks like the values are being set to the 'NAME' field. The 'LEA' is an integer field. right now the goDistrict() is just alerting the value of the selected option. The alert is coming back empty

<form name=choose_campus action=/website/schools/MakeDistrictMap.php method=post><P align=center><select name=school_dist onchange=goDistrict()><option value=>Alma</option><option value=>Alpena</option><option value=>Altheimer Unified</option><option value=>Arkadelphia</option><option value=>Armorel</option><option value=>Ashdown</option><option value=>Atkins</option><option value=>Augusta</option><option value=>Bald Knob</option><option value=>Barton-Lexa</option><option value=>Batesville</option><option value=>Bauxite</option><option value=>Bay</option><option value=>Bearden</option><option value=>Beebe</option><option value=>Benton</option><option value=>Bentonville</option><option value=>Bergman</option><option value=>Berryville</option><option value=>Bismarck</option><option value=>Black Rock</option><option value=>Blevins</option><option value=>Blytheville</option><option value=>Booneville</option><option value=>Bradford</option><option value=>Bradley</option><option value=>Brinkley</option><option value=>Brookland</option><option value=>Bryant</option>
<option value="" selected> --Select a District-- </option>
</select>
//<input type="button" name="btnCampus" value="Go!" onClick="goDistrict()">
</form> </P></FONT>
</body>
</html>

TheDefender

The alert is coming back empty, because all of the values are empty... Get into the habit of quoting ALL of your attributes in ALL of your HTML tags. Not only is it good coding practice, but it is something that will help you avoid tons of headaches in the future (This should sound familiar, as I believe I remember mentioning this in a different thread of yours. I went back and bolded that statement for you in this thread):

$db_connect = mssql_connect('FWM-Data', 'tmp_PHP', '!qsplwd12');  

mssql_select_db('master', $db_connect);  

$query1 = "SELECT DISTINCT(NAME) FROM School_Districts";  

$result1 = mssql_query($query1); 
print "<form name=\"choose_campus\" action=\"".$_SERVER['PHP_SELF']."\" method=\"post\">"; 
print "<P align=\"center\"><select name=\"school_dist\" onchange=\"goDistrict()\">"; 
while($district = mssql_fetch_array($result1)){  

    print "<option value=\"".$district['LEA']."\">".$district['NAME']."</option>";
} //end while 
print "<option value=\"\" selected> --Select a District-- </option>";
print "</select>";

If that doesn't work for you then check these things:
1) Make sure your javascript function is looking for the right select name: school_dist
2) Make sure your Value's index matches the index field name from your DB (Remember, it's case sensitive).
3) Make sure your LEA fields are actually populated with data in your DB for each row.

it_is_spatial

Ok. I had already checked 2 of your recommendations. The database search is looking at the correct database. The table has an LEA value for all of the records. The alert is looking at the correct select. I even changed the reference to the 'LEA' field to the 'NAME' Field and it returns the selected 'NAME'. I'm a little unsure as to number

2) Make sure your Value's index matches the index field name from your DB (Remember, it's case sensitive).

I checked that the column name was LEA (case sensitive). but i'm not sure what your meaning.

I even tried changing from the LEA field to another field in the table and still getting an empty alert.

TheDefender

Regarding # 2, that was what I meant.

Regarding the rest... Did you clean up the code, and quote your attributes?

For testing purposes, change the positions of the LEA and the NAME in the option to see if the value of the option is returned when it is the NAME instead of the LEA field.

ie.

print "<option value=\"".$district['NAME']."\">".$district['LEA']."</option>";

[edit] I just caught this in your post:

I even tried changing from the LEA field to another field in the table and still getting an empty alert.

So flipping the values won't make a difference anyhow. If all of that is good to go, and your attributes are quoted, then it's more than likely something in your JS function.

it_is_spatial

Ok. Strangeness. I double checked the quoting and it's all good. I went ahead and tried switching the values like you said. Now the pulldown is a list of blanks. and when I choose one it alerts the 'NAME' correctly. It's like it knows theres something there its just not showing the value.

you can see it at this link.
Just select 'Make a district map'

www.facilitymaps.state.ar.us

Note: I've got the other pulldown working (Make a campus map)
using pretty much the same code but with two pulldowns.

You might recognize it. You helped me with it before.

gufmn

Ok, I've thought about this for a while and I think it might be your sql statement.

$query1 = "SELECT DISTINCT(NAME) FROM School_Districts"

to me, looks like it's only pulling NAME.

Try something like this:

$query1 = "SELECT DISTINCT(NAME, LEA) FROM School_Districts";

it_is_spatial

That was it. Had to search alittle for the syntax but this is what it ended up bein

SELECT DISTINCT NAME,LEA FROM School_Districts ORDER BY NAME

Thanks a million for helping me so much. Do you take paypal...lol

TheDefender

Good catch gufmn... I started looking at the syntax problems right away, I completely overlooked the Query.... D'OH! it_is_spatial, be sure to mark the thread resolved, and have a nice one.