I need to retrive all info including date from my database for editing. All

[Raadha]

<?php


$con=mysqli_connect("localhost","root","","trial");

if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }


if(isset($_POST['submit']))
{
$day = $_POST['day'];
    {



$result = mysqli_query($con,"SELECT * FROM cust WHERE DATE(day)= '$day'");}

while($row=mysqli_fetch_array($result))  
 {
echo " <br><br><h2> EDIT Record of " . $row['name'] . " for the day " .$row['day'] . "</h2>";  

echo " Name <input type='text' name='name' size='20' value= '   $row[name] ' /> <br>";
echo " Benificiary<input type='text' name='name' size='20' value= '   $row[beni] ' /> <br>";
echo " Hospital No <input type='text' name='name' size='20' value= '   $row[mrd] ' /> <br>";
echo "Customer No <input type='text' name='name' size='20' value= '   $row[cusno] ' /> <br> ";
echo "Date Of Admission<input type='date' name='name' size='20' value= '   $row[doa] ' /><br> ";
echo "Date Of Discharge <input type='date' name='name' size='20' value= '   $row[dod] ' /><br> ";
echo "Date Of Operation<input type='date' name='name' size='20' value= '   $row[doo] ' /><br> ";

}
mysqli_close($con);
?>

[decade]

Please read this link
http://www.daniweb.com/web-development/php/threads/435023/read-this-before-posting-a-question