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. Link to comment https://forums.phpfreaks.com/topic/41170-wondering-why-this-doesnt-work-in-ie/ 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. Link to comment https://forums.phpfreaks.com/topic/41170-wondering-why-this-doesnt-work-in-ie/#findComment-199418 Share on other sites More sharing options...
Greaser9780 Posted March 4, 2007 Author Share Posted March 4, 2007 NOPE didn't do it Link to comment https://forums.phpfreaks.com/topic/41170-wondering-why-this-doesnt-work-in-ie/#findComment-199422 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. Link to comment https://forums.phpfreaks.com/topic/41170-wondering-why-this-doesnt-work-in-ie/#findComment-199427 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. Link to comment https://forums.phpfreaks.com/topic/41170-wondering-why-this-doesnt-work-in-ie/#findComment-199431 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; } Link to comment https://forums.phpfreaks.com/topic/41170-wondering-why-this-doesnt-work-in-ie/#findComment-199436 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! Link to comment https://forums.phpfreaks.com/topic/41170-wondering-why-this-doesnt-work-in-ie/#findComment-199439 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.