Select Problem??

justjohn

Ok, so I have scoured the net and don't seem to find an answer. . . .

I am trying to figure out how to select all records from a table, but only show one specific id. So, yeah, I can add the WHERE id = $id to the query, but then I only get the one record.

What I'm getting at is that I want to add the typical PREV and NEXT links to the entire recordset. So the user can view the one entry they asked for but then keep browsing the database.

if I just get 'em all, then I need to find and display only the one I want. So, I need to loop through the recordset, find the matching record, and figure out what position that is in the overall recordset so I can build the PREV/NEXT links.

Make sense?? I hope so. Sorry if this has been done before. I have looked here and elsewhere, but in my feeble brain, I still can't make sense of it.

Thanks greatly,

John

LordShryku

Just search the forums or pagination.

justjohn

Yo, Lord, thanks, but maybe I'm just a slow learner. . .

None of the examples I searched for seemed to have what I'm looking for.

I can get the general pagination stuff OK, but I still couldn't see anything showing a specific record (not the first) while building the pagination links for the entire record set.

Again, it seems that if I add a WHERE id = $id to the SELECT statement, I only get that record.

And if I get 'em all, then I need to show only the one they asked for (while building the pagination links for the prev/next in the array)

Forgive me, but I really have tried to find the answer to this.

Thanks in advance,

John

bunner_bob

This is a clumsy idea, but I'll just shoot it out anyway.

Say you have 100 records and the user hits #53 first. Your "back" button could activate a loop that starts looking for id=52 first, decreasing by one each loop. If it doesn't find something it'd go to the next iteration. If it hits, it displays it and breaks the loop.

So it would look something like this:

$start = $thisid - 1;
for ($i = $start; $i > 0; $i--) {
(select from the db where id = this id)
if (mysql_num_rows($result) > 0) {
display the result;
break;
}
}

"next" button would start where $start = $thisid + 1, and do $i++ for each loop.

Of course you're hitting the database each loop. I'm sure there's a much cleaner way to do this, working off a fully retrieved set of results. Some way to step through the ids in the result. But at least here's a messy alternative. :-)

justjohn

Bob-

Thanks for the idea. Yeah, I suppose accessing the DB everytime is not the most desireable, but . . .

The other problem is that I am sorting by a field other than $thisid to get the results in a more "friendly" listing.

This is really just a contact database, but since I wanna learn more about this stuff, I thought I'd do it by hand instead of find some code already built.

Silly me.

-John