NEVERMIND: mysql/php large integer query oddity
| From: | Steve Edberg | Date: | Wed, 13 Nov 2002 20:18:15 +0000 |
| Subject: | NEVERMIND: mysql/php large integer query oddity | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-124306@lists.php.net to get a copy of this message | ||
Boy do I REALLY need some coffee...one query was on the production database, the other was on the development copy. I suppose I should set the programmer_first_check_database_parameter_you_idiot setting in php.ini...
Sorry for consuming unnecessary list space.
<sound of head meeting door jamb repeatedly>
-steve
I have a query oddity that looks like an integer overflow, but it shouldn't be.
Excerpt from my program:
<snip>
#DEBUG
echo "\n<br>$Query<br>\n";
#DEBUG
$hResult = _do_query(__LINE__, $Query); # _do_query() simply executes mysql_query, and does nice error formatting if necessary
$First = true;
while ($Row = @mysql_fetch_array($hResult)) {
if ($First) {
$First = false;
show_table_open($Myself);
}
echo
'<tr bgcolor="', $TableColor['row1'], '">',
'<td>', $Row['source_code'], '</td>',
'<td>', $Row['chromo_code'], '</td>',
'<td>', $Row['type'], '</td>',
'<td align="right">', number_format($Row['min_exon_length']), '</td>',
'<td align="right">', number_format($Row['max_exon_length']), '</td>',
# '<td>', $Row['min_exon_length'], '</td>',
# '<td>', $Row['max_exon_length'], '</td>',
"</tr>\n";
}
<snip>
<SNIP>