Re: Need Table Joins Example

2004-05-17 Thread Garth Webb
On Sat, 2004-05-15 at 04:04, David Blomstrom wrote: > --- Jigal van Hemert <[EMAIL PROTECTED]> wrote: > > > If you need to know how to display the resulting > > record sets, example 1 on: > > http://www.php.net/manual/en/ref.mysql.php > > gives you a complete piece of code to print out the > > re

Re: Need Table Joins Example

2004-05-15 Thread Jigal van Hemert
Brad Eacker wrote: > Jigal van Hemert writes: > >Do you mean temporary tables? These are only necessary when there's no way > >to solve the problem with a join. > > Actually a temporary table can be used with a join to do what is usually > knows as a sub-select or sub query. In this fashion y

Re: Need Table Joins Example

2004-05-15 Thread beacker
Jigal van Hemert writes: >Do you mean temporary tables? These are only necessary when there's no way >to solve the problem with a join. Actually a temporary table can be used with a join to do what is usually knows as a sub-select or sub query. In this fashion you select the elements that wo

Re: Need Table Joins Example

2004-05-15 Thread David Blomstrom
--- Jigal van Hemert <[EMAIL PROTECTED]> wrote: > If you need to know how to display the resulting > record sets, example 1 on: > http://www.php.net/manual/en/ref.mysql.php > gives you a complete piece of code to print out the > resulting records. OK, I think this example points out what I'm doi

Re: Need Table Joins Example

2004-05-15 Thread David Blomstrom
--- Jigal van Hemert <[EMAIL PROTECTED]> wrote: Great, you've given me a lot of ideas (and examples) to play with. Thanks! __ Do you Yahoo!? SBC Yahoo! - Internet access at a great low price. http://promo.yahoo.com/sbc/ -- MySQL Genera

Re: Need Table Joins Example

2004-05-15 Thread Jigal van Hemert
> I think part of the confusion stems from the dynamic > tables I was creating with Dreamweaver. I thought they > were a necessary part of the equation, when they may > in fact be optional. Do you mean temporary tables? These are only necessary when there's no way to solve the problem with a join.

Need Table Joins Example

2004-05-14 Thread David Blomstrom
I'm trying to learn how to join tables, but I'm doing something wrong. I've found lots of examples that look easy, but something isn't clicking. I think part of the confusion stems from the dynamic tables I was creating with Dreamweaver. I thought they were a necessary part of the equation, when t