Re: Excluding records from repeat region in PHP

> This will work even if there are many more fields in your products table
> that you also wish to show.
>
> - steve

Another thought, now that I just read what I sent: If my post above is the
solution you seek, then the important thing here is you can save yourself
an enormous amount of effort and code lines by having the database do as
much as possible for you, rather than the PHP code.

You should do this whenever possible. But don't forget that when things
get complicated with lots of joins, you should analyze the queries to
locate slow queries (joins can produce big intermediate results), and add
the appropriate indexes when needed. Amazing, what difference this makes.

- steve
.

Relevant Pages

  • Re: date function sometimes returns the wrong day
    ... Andrew DeFaria wrote: ... > I have the following php code: ... on the computer running your browse. ... Steve ...
    (comp.lang.php)
  • Re: Homosexuals
    ... Socrates taught his students that the pursuit of truth can only begin once ... they start to question and analyze every belief that they ever held dear. ... God created Adam and Steve, but Steve was a woman traped in a man's body ... God, Queen and country! ...
    (rec.arts.drwho)
  • Re: recovering email that never quite made it
    ... My DBXpress program will analyze the entire hard drive for messages, so it might be able to find them. ... But there's no way of knowing without running it. ... "Steve" wrote in message ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)