<?php include("includes/connection.php");?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<?php

echo $sql= "SELECT * FROM forms WHERE today >= CURDATE() - INTERVAL 30 DAY";
$result=mysql_query($sql);
while($row=mysql_fetch_array($result))
{echo $City= $row['City'];
echo $Name=$$row['Name'];}
?>

</body>
</html>

i just don't know how to do it, i want to search forms submitted in last 30 days, please help me. above query not selecting any row. attached is a image of database in which dates gets saved by

date("F j, Y");

. please help me.

Re: Search for last 30 days entries 80 80

The first place to look is the Date/Time functions in the manual page:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-sub SELECT * FROM forms WHERE today >= DATE_SUB( CURDATE(), INTERVAL 30 DAYS)

Re: Search for last 30 days entries 80 80

Are you sure you want 30 days? An alternative would be

SELECT * FROM forms WHERE today >= DATE_SUB( CURDATE(), INTERVAL 1 month)
Re: Search for last 30 days entries 80 80

Are you sure you want 30 days? An alternative would be

SELECT * FROM forms WHERE today >= DATE_SUB( CURDATE(), INTERVAL 1 month)

have tried it, both with days and month, but don't know why , it is giving a problem, this error it is showing up.

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DAYS) LIMIT 0, 30' at line 1

Re: Search for last 30 days entries 80 80

The days condition in the 2nd parameter to date_sub should read DAY (without the plural "s").

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.