twilitegxa Posted January 30, 2010 Share Posted January 30, 2010 I have the following HTML page: <form> Select a character: <?php $get_scouts = "select * from scouts where username = '".$_SESSION['userName']."'"; $get_scouts_res = mysql_query($get_scouts, $conn) or die(mysql_error()); echo "<select name=\"users\" onchange=\"showUser(this.value)\"> <option selected=\"selected\">None Selected</option>"; while ($list_scouts = mysql_fetch_array($get_scouts_res)) { $identity = ucwords($list_scouts['identity']); $topic_id = $list_scouts['id']; echo "<OPTION value=\"$topic_id\">$identity</OPTION>"; } echo "</select>"; ?> </form> <br /> <div id="txtHint"></div> </div> And then a JavaScript gets this PHP script to display the information once selected: <?php $q=$_GET["q"]; $con = mysql_connect('localhost', 'root', ''); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("smrpg", $con); $sql="SELECT * FROM derived_values WHERE id = '".$q."'"; $result = mysql_query($sql); echo "<table border='1'> <tr> <th>Identity</th> <th>Health</th> <th>Energy</th> <th>Attack</th> <th>Defense</th> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['identity'] . "</td>"; echo "<td>" . $row['health'] . "</td>"; echo "<td>" . $row['energy'] . "</td>"; echo "<td>" . $row['acv1'] . "</td>"; echo "<td>" . $row['dcv1'] . "</td>"; echo "</tr>"; } echo "</table>"; mysql_close($con); ?> I want to know, how can I make an if statement that hides the table if the "None Selected" value is chosen from the select option list? I know it would be like: if (something == "None Selected") { div id "txtHint" display: none} else { execute the code I already have } I just don't know exactly how to write it. Can anyone help? 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.