Need one more quote (se below) Of course that's a mysql parse error!!!!!!
Mysql dates are YYYY-MM-DD. Do NOT use slashes $query = "SELECT * FROM table where date >= \"$year_1-$month_1-$day_1/$year_1\" AND date <= \"$year_2-$month_2-$day_2\""; Read the mysql manual concerning dates, formats, functions -----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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
