At 12:43 29/12/2008, you wrote:
Message-ID: <008b1179ce594ebea03cb06480182...@dragon>
From: "Keith Spiller"
To: "php_db"
Date: Sun, 28 Dec 2008 17:39:08 -0700
MIME-Version: 1.0
Content-Type: text/plain;
format=flowed;
charset="iso-8859-1";
reply-type=original
Content-Tra
On Mon, Dec 29, 2008 at 10:17 AM, Keith Spiller wrote:
> Another option that would work if I can figure out the correct syntax is to
> just NULL certain values if a given condition exists. If
> product_type='course' then just use the o.product_id value for field4. If
> product_type != 'course' t
That looks like it should work, just execute the select query and see what
is the output
Jack
2008/12/29 Keith Spiller
> Another option that would work if I can figure out the correct syntax is to
> just NULL certain values if a given condition exists. If
> product_type='course' then just use
Another option that would work if I can figure out the correct syntax is to
just NULL certain values if a given condition exists. If
product_type='course' then just use the o.product_id value for field4. If
product_type != 'course' then use NULL for field4.
CREATE TABLE $table[name]
SELECT f