Hi, doubtles an easy one for PHP / MySQL gurus:
How do I find the position of a specific row in a table in order to be sure to include it when using a LIMIT clause?
I have a catalog database and want to display a list screen limited to only about 15 items, being sure to include a specific item (based on catalog number). The need arises as I will be displaying the list following an individual record screen of the item in question and do not want it to have vanished when others appear.
Catalog number is the value I know but the sort order in the list is date_made which may complicate things a little.
Any help much appreciated!
...Ian
