RE: [PHP] can't get it to work
| From: | Rick Emery | Date: | Wed, 03 Apr 2002 19:10:09 +0000 |
| Subject: | RE: [PHP] can't get it to work | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-91362@lists.php.net to get a copy of this message | ||
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:aarmis@hotmail.com]
Sent: Wednesday, April 03, 2002 12:19 PM
To: php-general@lists.php.net
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