MySQL Query works in PHPMyAdmin but not in PHP

Question

I've been trying to get for examples rows 100 through 200 from a table of 1000+ rows. I found this snippet online that seems to work perfectly in PHPMyAdmin but when I try to use it in code, it won't work.

    SELECT * 
FROM ( 
    SELECT 
        @row := @row +1 AS rownum, id
    FROM ( 
        SELECT @row :=0) r, myGames
    ) ranked 
WHERE rownum >= 100 AND rownum < 200"

Here is my PHP Code

$q = "SELECT * 
FROM ( 
    SELECT 
        @row := @row +1 AS rownum, id
    FROM ( 
        SELECT @row :=0) r, myGames
    ) ranked 
WHERE rownum >= 100 AND rownum < 200";

$query = mysql_query($q);

When I try to do $query = mysql_query($q) or die(mysql_error()), I get nothing.

Any help with this is greatly appriciated

EDIT: SOLVED by using LIMIT 100,100. Thanks guys

Does $query return a value? tried a var_dump($query) to check that it's actually failing? — bear
– bear, Commented Nov 18, 2012 at 20:42
Why not just use LIMIT 100,100? That'd give you the 100-200 result range, without the extra sub-queries... — Nick
– Nick, Commented Nov 18, 2012 at 20:43
mysql_*() functions are to no longer be used and will be removed in future releases. Please us MySQLi or PDO. — user1592648
– user1592648, Commented Nov 18, 2012 at 20:44

Olaf Dietsche · Accepted Answer · 2012-11-19 06:47:28Z

3

If you want to retrieve a subset of your result set, use limit offset, num_rows

select id
from myGames
limit 100, 100;

edited Nov 19, 2012 at 6:47

answered Nov 18, 2012 at 20:47

Olaf Dietsche

74.4k9 gold badges113 silver badges214 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL Query works in PHPMyAdmin but not in PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related