[wp-hackers] Hijack "The Loop"?

[Lorin Rivers]

OK, that's good to know. Can you tell me how to retain/access a query so
that I can apply LIMIT to it and get the next item?

On 4/26/07, Otto <otto at ottodestruct.com> wrote:
>
> The thing I think you're missing is an understanding of the MySql LIMIT
> clause.
>
> SELECT * FROM your_table LIMIT 5, 10
>
> That will select 10 entries from "your_table", skipping the first 5 of
> them. So you will get entries 6,7,8,9,10,11,12,13,14, and 15,
> basically.
>
> This is how Wordpress does the post loops, more or less. Each "page"
> has X entries. Page 1 starts with entry 0. Page 2 starts with entry
> number X. Page 3 starts with entry 2X. And so on.
>
> So your "profile" page could be the same as your normal query (more or
> less), but with a LIMIT of X,1, where X is the number of that person
> in the result set (0-indexed). To get the next guy, you run the same
> query with X+1.
>
> I cannot tell you specifically how to apply this to your application,
> but the gist of it is that Wordpress does not really retain the query
> from page to page. It builds the same query that it did before, but
> with new variables for the LIMIT clause.
>
>
>
> On 4/25/07, Lorin Rivers <lrivers at gmail.com> wrote:
> > Paul is my hero, he got me to this point.
> >
> > Take a look at my follow-up, though.
> >
> > On 4/25/07, Paul Menard <codehooligans at codehooligans.com> wrote:
> > > No. You really don't want to do that. I can answer this because well
> > > I know what you are working on.
> > >
> > > For example on the custom search result page. If the your secret
> > > 'alum_search' parameter is present you are dropping into your custom
> > > SQL query which hits you alumni table and searched for matching
> > > records. the result of this query is a standard mysql array (see my
> > > example below). If you don't have the secret 'alum_search parameter
> > > then you default to using the WP Loop to display any Post/Page items.
> > > You really can't hijack the loop since your table columns don't
> > > really apply to WP functions like the_title(), the_content(), etc.
> > >
> > > For your custom query you just need to make your own loop and display
> > > the row information from your alumni contact table Something like the
> > > following. This is straight from the PHP MySQL manual.
> > >
> > > $query = "SELECT..."; // your custom quuery
> > > $result = mysql_query($query);
> > > while ($row = mysql_fetch_assoc($result))
> > > {
> > >      echo $row['firstname'];
> > >      echo $row['lastname'];
> > >      echo $row['address'];
> > >      echo $row['age'];
> > > }
> > > mysql_free_result($result);
> > >
> > > P-
> > >
> > >
> > > On Apr 25, 2007, at 1:22 PM, Lorin Rivers wrote:
> > >
> > > > Here's what I'm doing--I've got a custom table and some page
> > > > template-fu to display data that is not "posts". WP is so
> post-centric
> > > > that a lot of stuff doesn't work if the content is not in "the
> loop".
> > > >
> > > > Is it possible to make my custom PHP ACT like The Loop? And if so,
> > > > how?
> > > >
> > > > Thanks!
> > > > _______________________________________________
> > > > wp-hackers mailing list
> > > > wp-hackers at lists.automattic.com
> > > > http://lists.automattic.com/mailman/listinfo/wp-hackers
> > > >
> > >
> > > _______________________________________________
> > > wp-hackers mailing list
> > > wp-hackers at lists.automattic.com
> > > http://lists.automattic.com/mailman/listinfo/wp-hackers
> > >
> > _______________________________________________
> > wp-hackers mailing list
> > wp-hackers at lists.automattic.com
> > http://lists.automattic.com/mailman/listinfo/wp-hackers
> >
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>