From: Steve D. <sd...@ne...> - 2004-04-01 02:54:26
|
> >I kind of hit a snag in wondering how > > to display rows, and then an edit option. The question is how to > > index those rows if there is no index, etc. > > This is tricky... I have not even thought about it. > maybe use all the rows for the "where" clause? it's ugly, but at first > thought it should work... The other thought that occurred to me, was to pass the same query to the edit_row.php (or whatever the filename is) and then index on the row # from the table_browse.php. So, for instance, if you're doing select * from my_table order by blah offset 30 limit 10;, and you want to edit the 5th row down, you would just pass that same query to the edit page, and then either jump to the 5th row in a loop, or add 5 to the offset or something... Sounds like it'd work in theory. I'd have to actually try it to see. Steve |