Why my table data is not display

[Ashish Sood]

if(isset($_POST['submit'])){	 $selectcondition = "SELECT * FROM turnovers where INCIDENTID='".$_POST['search']."'"; //Select Query Which check the date whether the checklist for the given date is exit or not.	 $check=mysql_query($selectcondition,$con);	 $fetch=mysql_fetch_assoc($check);	 $status = mysql_query("SELECT STATUS FROM turnovers where INCIDENTID='".$_POST['search']."'");	 $fetch_status=mysql_fetch_assoc($status);	  	if(!$fetch) //If checklist for the given date is not exit execute if condition{			    echo '<font color="red">';  echo "<br>";  echo "No Incident Found In The Database";  echo "<br>";			    echo "</font>";}if ($fetch_status['STATUS'] =="closed"){  echo "<table width='100%' height='10%' border='1' cellspacing='0'>			     <tr bgcolor='#3399FF'>				   <th>DATE</th>				   <th>CITY</th>				   <th>SAMPLE</th>				   <th>NAME</th>								 </tr>";  while($records = mysql_fetch_array($status))		   {  			  echo "<tr bgcolor='#009999'>";			  echo "<td>" . $records['DATE'] . " </td>";			  echo "<td>" . $records['CITY']. " </td>";			  echo "<td>" . $records['SAMPLE'] . " </td>";			  echo "<td>" . $records['NAME'] . " </td>";      } 				  echo "</table>";}   

The First if block is executed successfully but my second if block is half executed mean only the table heading is printed on the form but the table not data. please let me know what wrong in my second if block.

[Don E]

May or may not be the issue but it looks like you're missing a closing brace } for either the first if statement block:if(isset($_POST['submit'])) or this one: if ($fetch_status['STATUS'] =="closed").

[Ashish Sood]

I closed the isset function braces is not the issues , Because page is loaded without any problem but field data is not retrieved.

[dsonesuk]

you have only chosen the status field to show"SELECT STATUS FROM turnovers where INCIDENTID='".$_POST['search']."'"if you want the rest you will have to list them as well or use 'SELECT *' as in all.