COUNT within LIMIT

[Canman2005]

Hi all

 

I have a query to grab all rows in my table but it has a LIMIT 20 on it, so it just grabs the first 20 rows.

 

I want to do a

 

SELECT COUNT(*) as Num FROM

 

but only do a count within the LIMIT I have set for my query.

 

Is this possible?

[BioBob]

LIMIT should accept two arguments.  If its given just one it takes it as the high end.  Like ...LIMIT 20; and LIMIT 0,20; are the same.  You can change the 0 to make that your starting point, so for 20 rows starting at 10 it would be LIMIT 10, 30;

 

Is that what you were asking or did I misunderstand you?

[sasa]

1st grab data and then count grabed rows

 

@BioBob

Format of LIMIT in MySQL is 'LIMIT start, lenght', not 'LIMIT start, end'

[Adam]

$limit = 'LIMIT 0, 20';

mysql_query("SELECT * FROM ... {$limit}");

// blah blah
// do some stuff!

mysql_query("SELECT COUNT(*) as Num FROM ... {$limit}");

 

If you were wanting to pass the start value in the URL like say: "?start=20" you could use:

 

$start = (!$_GET['start']) ? 0 : (int) $_GET['start'];
$limit = 'LIMIT {$start}, {$start+20}';

 

(no code tested)

 

Adam

[Canman2005]

thanks guys, much help