that worked perfectly! thank you so much!
-jon
-Original Message-
From: Rick Widmer [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 22, 2002 6:08 PM
To: Jonathan Narong; David Elliott; Jonathan Narong on PHP-DB
Subject: Re: [PHP-DB] RE: regarding multiple joins
At 05:26 PM 11/22/02
At 05:26 PM 11/22/02 -0800, Jonathan Narong wrote:
sorry for my confusing email... i'll try to clarify what i was asking:
i have two tables (i shortened them to only show the parts relating to what
i'm trying to do now) ...
CREATE TABLE articles (
id smallint(4) unsigned zerofill NOT NULL auto
sorry for my confusing email... i'll try to clarify what i was asking:
i have two tables (i shortened them to only show the parts relating to what
i'm trying to do now) ...
CREATE TABLE articles (
id smallint(4) unsigned zerofill NOT NULL auto_increment,
title varchar(40) NOT NULL default '',
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Greetings Jonathan
On 22 November 2002 at 01:55:10 -0800 (which was 09:55 where I live)
Jonathan Narong graced us with these comments
> i have an table 'articles' which has multiple fields, such as author,
> editor, photographer, etc.. each of these
hi,
you could do this with a join, but i experienced single querys to be faster if
you always have only one person_id to look for in person.
if it was many person_ids and your query would end like "...person_id in
(1,2,3, 9998)" a join would by faster, I guess.
feal free to correct me, if I'm
