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.



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

Reply via email to