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 <

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

$ticket_query = mysql_query("SELECT * FROM opentickets WHERE AskDate <

Just thought I would share this.
Edit bug report at:

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to