Tuesday, February 23, 2016

In the database there are more entries of created_date field. so how to get firstly inserted created_date from database table base on the user_email id because user_email email inserted more times .


In this we are use min aggregate function for getting the firstly inserted date .

$sql="select min(created_user_date) as first_created_date from users where user_email='$email'";// where $email is the users input.
mysql_query($sql);
echo $first_created_date;

No comments:

Post a Comment

Featured Post

What is JavaScript? What is the role of JavaScript engine?

  The JavaScript is a Programming language that is used for converting static web pages to interactive and dynamic web pages. A JavaScript e...