Have you tried BETWEEN $query = SELECT * FROM table where date BETWEEN '$month_1/$day_1/$year_1' AND '$month_2/$day_2/$year_2';
Robert W. Collins II Webmaster New Orleans Regional Transit Authority Phone : (504) 248-3826 Email : [EMAIL PROTECTED] -----Original Message----- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 12:19 PM To: [EMAIL PROTECTED] Subject: [PHP] can't get it to work I'm trying to write code that will return all records found between certain dates(e.g. 2001-01-30 through 2002-01-30). I created a html form with pull down menus for both dates but when I try to run it I get a parse error and can't figure out what's wrong. Thanks, Alex Here is the php code: $month_1 = addslashes($date_month_1); $day_1 = addslashes($date_day_1); $year_1 = addslashes($date_year_1); $month_2 = addslashes($date_month_2); $day_2 = addslashes($date_day_2); $year_2 = addslashes($date_year_2); $query = SELECT * FROM table where date >= '$month_1/$day_1/$year_1' AND date <= '$month_2/$day_2/$year_2'; $result = mysql_query($query); $num_results = mysql_num_rows($result); echo "<p>Number of records found: ".$num_results."</p>"; for ($i=0; $i <$num_results; $i++) { $row = mysql_fetch_array($result); echo "<p><strong>".($i+1).". ID: "; echo stripslashes($row["id"]); echo "</strong><br>First name: "; echo stripslashes($row["fname"]); echo "<br>Last name: "; echo stripslashes($row["lname"]); } ?> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
