how to get date from table then store it to variable in php
<p>I have a table that stores current_date by timestamp when users get registered.</p>

<pre><code>seeker
name.. current_date
ali...2012-04-22 22:12:36
</code></pre>

<p>Now I have to store this date in some variable.  I am using this query:</p>

<pre><code>$uname= $_REQUEST['name2']; 

$qry5= "select current_date from seeker where name='$uname'";
                $res4=mysql_query($qry5, $con);
                $rs5= mysql_result($res4,0); 
                echo $rs5;
</code></pre>

<p>This query should return the date that is stored in the correspondence of user "2012-04-22", but this query returns the date of today "2012-05-02".  Please tell me where I made mistakes. Thanks in advance.</p>
