How to fix my date problem
<p>what i want is this the date variable which i insert and select back in my table to echo should display the correct date like today date is 2005-10-27 when i insert the variable date and select to echo it display this 2012-10-20 also my U_date field i choose date for the type lastly how can i make the date to look like this 10-June-2010 not like this 10-6-2010</p>

<pre><code>&lt;?
 $name= ($_POST['name']);
  $u_date = date ('h.m.Y');

  mysql_query("INSERT INTO user
  (name, u_date) VALUES('" . $name . "', '" . $u_date. "')

 $query1 = "SELECT * FROM user";
 $result1 = mysql_query ($query1) or die('query error');
 $line = mysql_fetch_assoc($result1);

 $d_user = $line[name];
 $d_date = $line[u_date];

 echo"$d_user&lt;br&gt;$d_date";
?&gt;
</code></pre>
