PHP dropdown and table problem?
<p>Hello I want to show a table that have all the values from a mysql table but depending on the values that I will select from a dropdown menu. For example the dropdown list menu have a value named open. I just want to see the rows from the table that have that status. I will need to use Ajax for this?</p>

<p>Here is my code?</p>

<p><pre><code>
$status = $_POST['TipoStatus'];</p>

<p>echo '  Create Service ';
echo '';
echo ' Status:';
$query = "SELECT TipoStatus FROM status"; // First Remar
         $result = queryMysql($query);</p>

<pre><code>        if (!queryMysql($query)) {
echo "Query fail: $query&lt;br /&gt;" .
        mysql_error() . "&lt;br /&gt;&lt;br /&gt;";
                        }
else
</code></pre>

<p>{
echo ''; // or name="toinsert[]"
// echo 'None';
while ($row_1 = mysql_fetch_array($result)) {
  echo '' // Third remark</p>

<p>. htmlspecialchars($row_1['TipoStatus'])
  . '';</p>

<p>}
echo '';
echo '</p>';
}</p>

<p>echo '';</p>

<p>echo '';</p>

<p>echo '';
echo ' Service ID';
echo 'Title';
echo 'Description';
echo 'Notes';
echo 'Submit By';
echo 'Assigned Employee';
echo 'Assigned Group';
echo 'Category';
echo 'Status';
echo 'Urgency';
echo 'Customer';
echo 'Day Created';
echo '';</p>

<p>$query = ("SELECT ServiceID, Title, Description, Notes, SubmitBy, AssignedEmp, " .
"AssignedGroup, NameCategory, TipoStatus, TiposUrgencia, CustomerName, DayCreation FROM Service where TipoStatus = '$status'  ");
$result = queryMysql($query);
echo 'resultado' . mysql_num_rows($result);</p>

<p>while ($row = mysql_fetch_assoc($result)) {</p>

<code>echo '&lt;tr&gt;';

echo '&lt;td&gt;&lt;a href="rnservices1.php?ServiceID='.$row["ServiceID"].'"&gt; '.$row['ServiceID'] .' &lt;/a&gt;&lt;/td&gt;';
echo '&lt;td&gt;' .$row['Title']. ' &lt;/td&gt;';
echo '&lt;td&gt;'.$row['Description'].'&lt;/td&gt;';
echo '&lt;td&gt;'.$row['Notes'].'&lt;/td&gt;';
echo '&lt;td&gt;'.$row['SubmitBy'].'&lt;/td&gt;';
echo '&lt;td&gt;'.$row['AssignedEmp'].'&lt;/td&gt;';
echo '&lt;td&gt;'.$row['AssignedGroup'].'&lt;/td&gt;';
echo '&lt;td&gt;'.$row['NameCategory'].'&lt;/td&gt;';
echo '&lt;td&gt;'.$row['TipoStatus'].'&lt;/td&gt;';
echo '&lt;td&gt;'.$row['TiposUrgencia'].'&lt;/td&gt;';
echo '&lt;td&gt;'.$row['CustomerName'].'&lt;/td&gt;';
echo '&lt;td&gt;'.$row['DayCreation'].'&lt;/td&gt;';

echo '&lt;/tr&gt;';
</code></pre>

<p>}</p>

<p>mysqli_free_result($result);</p>

<p>echo $ticket_select;enter code here</code></p>

<p>echo '';
echo '';
 ?></p>
