From:             mateusz dot goik at aliantsoft dot pl
Operating system: 
PHP version:      Irrelevant
Package:          Website problem
Bug Type:         Bug
Bug description:bug.php.net - mysql error - begin

Description:
------------
Hi,

https://bugs.php.net/search.php?cmd=display&begin=1 -> OK
https://bugs.php.net/search.php?cmd=display&begin=-1 -> ERROR

File:
https://svn.php.net/viewvc/web/php-bugs/trunk/include/query.php?view=markup

................
38      $begin = (int) (!empty($_GET['begin']) ? $_GET['begin'] : 0);
................
240     if ($limit != 'All' && $limit > 0) {
241     $query .= " LIMIT $begin, $limit";
242     }
................

Fix: $begin >= 0

mysql example:
select 1 limit 0,1 -> OK
select 1 limit -1,1 -> ERROR




-- 
Edit bug report at https://bugs.php.net/bug.php?id=64020&edit=1
-- 
Try a snapshot (PHP 5.4):   
https://bugs.php.net/fix.php?id=64020&r=trysnapshot54
Try a snapshot (PHP 5.3):   
https://bugs.php.net/fix.php?id=64020&r=trysnapshot53
Try a snapshot (trunk):     
https://bugs.php.net/fix.php?id=64020&r=trysnapshottrunk
Fixed in SVN:               https://bugs.php.net/fix.php?id=64020&r=fixed
Fixed in release:           https://bugs.php.net/fix.php?id=64020&r=alreadyfixed
Need backtrace:             https://bugs.php.net/fix.php?id=64020&r=needtrace
Need Reproduce Script:      https://bugs.php.net/fix.php?id=64020&r=needscript
Try newer version:          https://bugs.php.net/fix.php?id=64020&r=oldversion
Not developer issue:        https://bugs.php.net/fix.php?id=64020&r=support
Expected behavior:          https://bugs.php.net/fix.php?id=64020&r=notwrong
Not enough info:            
https://bugs.php.net/fix.php?id=64020&r=notenoughinfo
Submitted twice:            
https://bugs.php.net/fix.php?id=64020&r=submittedtwice
register_globals:           https://bugs.php.net/fix.php?id=64020&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=64020&r=php4
Daylight Savings:           https://bugs.php.net/fix.php?id=64020&r=dst
IIS Stability:              https://bugs.php.net/fix.php?id=64020&r=isapi
Install GNU Sed:            https://bugs.php.net/fix.php?id=64020&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=64020&r=float
No Zend Extensions:         https://bugs.php.net/fix.php?id=64020&r=nozend
MySQL Configuration Error:  https://bugs.php.net/fix.php?id=64020&r=mysqlcfg


-- 
PHP Webmaster List Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to