[PHP-DB] Re: New Table Creation with PHP Variables

2008-12-30 Thread Neil Smith [MVP, Digital media]
At 12:43 29/12/2008, you wrote: Message-ID: 008b1179ce594ebea03cb06480182...@dragon From: Keith Spiller larent...@hosthive.com To: php_db php-db@lists.php.net Date: Sun, 28 Dec 2008 17:39:08 -0700 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset=iso-8859-1;

Re: [PHP-DB] Re: New Table Creation with PHP Variables

2008-12-29 Thread chris smith
On Mon, Dec 29, 2008 at 10:17 AM, Keith Spiller larent...@hosthive.com 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

[PHP-DB] Re: New Table Creation with PHP Variables

2008-12-28 Thread 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 the o.product_id value for field4. If product_type != 'course' then use NULL for field4. CREATE TABLE $table[name] SELECT

Re: [PHP-DB] Re: New Table Creation with PHP Variables

2008-12-28 Thread Jack van Zanen
That looks like it should work, just execute the select query and see what is the output Jack 2008/12/29 Keith Spiller larent...@hosthive.com 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