Jump to content

If Statement Help


twilitegxa

Recommended Posts

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?

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.