PHP MYSQL+How to retrieve record?

K

karthik

New member
I can't able to retrieve particular record by selecting date. My code is,
$factday=$_POST['factday'];
$factmonth=$_POST['factmonth'];
$factyear=$_POST['factyear'];

$factdate=($factyear.'-'.$factmonth.
'-'.$factday);
$factdate=date("Y-m-d",strtotime
("$factdate"));
$searchfact=$factdate;
{
echo $searchfact;
}
$query = mysql_query("select * from facts
where factdate='$searchfact'");
$result = mysql_query($query,$con) or

die(mysql_error());
-------------
In database, my factdate is '1947-08-15'
but, i can't retrieve record by selecting
this particular field. What i do?
 
Back
Top