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

Edited by Sahilsahni: n/a

Attachments search.JPG 15 KB
3
Contributors
4
Replies
7
Views
6 Years
Discussion Span
Last Post by smantscheff
0

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

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

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.