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
https://forums.phpfreaks.com/topic/190333-if-statement-help/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • 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.