Can anyone put if/else statement on this piece of script. I want it to detect if there's user in the database.
$query = "SELECT * from users WHERE username LIKE '%" .$haha. "%'";
$show = mysql_query($query);
while($row=mysql_fetch_array($show))
{
$datefromdb = $row[timef];
$year = substr($datefromdb,0,4);
$mon = substr($datefromdb,4,2);
$day = substr($datefromdb,6,2);
$hour = substr($datefromdb,8,2);
$min = substr($datefromdb,10,2);
$sec = substr($datefromdb,12,2);
$datefromd = $row[timefer];
$years = substr($datefromd,0,4);
$mons = substr($datefromd,4,2);
$days = substr($datefromd,6,2);
$hours = substr($datefromd,8,2);
$mins = substr($datefromd,10,2);
$secs = substr($datefromd,12,2);
$orgdate = date("l F dS, Y h:i A",mktime($hour,$min,$sec,$mon,$day,$year));
$orgdates = date("l F dS, Y h:i A",mktime($hours,$mins,$secs,$mons,$days,$years));
echo "$row[username] Registered since:$orgdate $orgdates<br>";
}
