Next 50 Records

[bruin03]

How do I grab the next 50 records in a database without an autoincrement value?

[ScallioXTX]

How do I grab the next 50 records in a database without an autoincrement value?

"Next 50" with respect to what?

[r937]

"Next 50" with respect to what?

[bruin03]

With respect to any random record in the database,
It can be the 50 after or the 50 before.

This is for an SEO function i'd like to make. Is this even possible?

Something tells me the min/max() functions should be able to do this?

Hm

[bruin03]

Does mysql have a row_number function?
Gosh, I wish the rows were numbered then I'd just use a limit clause at the end of my next select

[r937]

Something tells me the min/max() functions should be able to do this?

no, they won't help

what would you take the min/max of? see also post #2

[bruin03]

no, they won't help

what would you take the min/max of? see also post #2

Got it, hence I asked if Mysql had a row_number function to dynamatically assign row indexes?

Perhaps further explanation is in order... i have a parts database without auto-increment values. EAch time i query a partnumber, I'd also like to query the next 50 or X parts around it.

For instance if my part # is PX5400, i'd like to make another single query for PX5401 through PX5450 in the same run.

Does that make more sense? Any advice to how I could accomplish this given the first part# (PX4400). ?

[r937]

aha, finally we find something that can be used as a comparison to determine "noxt 50 by what" -- by increasing part number

so you need

SELECT ...
  FROM ...
ORDER BY partnumber LIMIT x,y

where x and y are numbers, e.g. 50,50 to skip over 50 rows and show the next 50

[bruin03]

aha, finally we find something that can be used as a comparison to determine "noxt 50 by what" -- by increasing part number

so you need

SELECT ...
  FROM ...
ORDER BY partnumber LIMIT x,y

where x and y are numbers, e.g. 50,50 to skip over 50 rows and show the next 50

Great!
Is there anywhere to determine X and Y from my current partnumber if there are no indexes?

[oddz]

Your "could" use GROUP_CONCAT() then explode and search for the index of the selected part. Then splice that array starting at the index and ending 50 items away. Then implode that array and embed it into a WHERE clause using an IN condition against the index. The only problem you would run into is when there aren't 50 item following the current one. In that case you could start from the beginning again if you "must" have 50 items.