Greaser9780 Posted March 4, 2007 Share Posted March 4, 2007 <?php $q=$_GET["q"]; include("db.php"); $sql="SELECT name FROM players WHERE position='".$q."' ORDER BY name ASC"; $result = mysql_query($sql); ?> <html> <head> </head> <body> <form action="select.php" method="post"> Comment:<input type='text' name='com' maxlength='80'><br> <select name="playername"> <?php while($row = mysql_fetch_array($result)) { echo "<option value='" . $row['name'] . "'>" . $row['name']."</option>" ; } ?> </select> <input type="submit" name="submit" value="select"> </form> </body> </html> At first I thought it was an AJAX issue but it's showing what it is supposed to show. The preceding script is what it is supposed to show. If I take out the "q" part it works fine. So I am wondering why Q is not passed in IE but it is in firefox. Quote Link to comment Share on other sites More sharing options...
Yesideez Posted March 4, 2007 Share Posted March 4, 2007 Try replacing $_GET with $_POST at the start. Quote Link to comment Share on other sites More sharing options...
Greaser9780 Posted March 4, 2007 Author Share Posted March 4, 2007 NOPE didn't do it Quote Link to comment Share on other sites More sharing options...
Yesideez Posted March 4, 2007 Share Posted March 4, 2007 Oh, just noticed you're using double quotes around "q" - try: $q=$_POST['q']; Never tried using double quotes so I don't know if that is where the fault lies but I'll carry on looking at the script. Quote Link to comment Share on other sites More sharing options...
Greaser9780 Posted March 4, 2007 Author Share Posted March 4, 2007 Tried that too. I just can't figure out why the variable gets passed in FF but not in IE makes no sense. If I take the q part out of the query it lists all 400 or so from the db. Quote Link to comment Share on other sites More sharing options...
Greaser9780 Posted March 4, 2007 Author Share Posted March 4, 2007 If it helps here is the file that shows the first dropdown: <html> <head> <script src="selectuser.js"></script> </head> <body> <div align="center"> <form> <select name="users" onchange="showUser(this.value)"> <option>QB <option>WR <option>RB <option>TE <option>K <option>DF </select> </form> </div> <div id="txtHint"> </div> </BODY> </html> And here is the js file: var xmlHttp function showUser(str) { xmlHttp=GetXmlHttpObject() if (xmlHttp==null) { alert ("Browser does not support HTTP Request") return } var url="showUser.php" url=url+"?q="+str url=url+"&sid="+Math.random() xmlHttp.onreadystatechange=stateChanged xmlHttp.open("GET",url,true) xmlHttp.send(null) } function stateChanged() { if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete") { document.getElementById("txtHint").innerHTML=xmlHttp.responseText } } function GetXmlHttpObject() { var xmlHttp=null; try { // Firefox, Opera 8.0+, Safari xmlHttp=new XMLHttpRequest(); } catch (e) { //Internet Explorer try { xmlHttp=new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { xmlHttp=new ActiveXObject("Microsoft.XMLHTTP"); } } return xmlHttp; } Quote Link to comment Share on other sites More sharing options...
Yesideez Posted March 4, 2007 Share Posted March 4, 2007 Ah! You're using Javascript - definitely not my area - sorry but I can't help there! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.