From: [EMAIL PROTECTED]
Operating system: FreeBSD
PHP version: 4.0.6
PHP Bug Type: MySQL related
Bug description: Query problem with Unix billions
I'm honestly not sure if this is a PHP bug or a MySQL bug. I apologize if
this is a waste of time. Here's an example script:
$timenow = time();
$red = ($timenow-345600);
$ticket_query = mysql_query("SELECT * FROM opentickets WHERE AskDate <
$red");
This query returns all tickets where AskDate is earlier than the $red date,
PLUS all tickets above 1 billion on the time stamp! Ack! I have resolved
this by removing the single quotes from around '$red' in my query, so it
reads:
$ticket_query = mysql_query("SELECT * FROM opentickets WHERE AskDate <
$red");
Just thought I would share this.
--
Edit bug report at: http://bugs.php.net/?id=13220&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
