<?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.

Recommended Answers

All 4 Replies

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

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

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

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.