NEVERMIND: mysql/php large integer query oddity

From: 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>

« previous php.general (#124306) next »