Re: Re: newbie lost on data import... part 2
| From: | John W. Holmes | Date: | Sun, 10 Aug 2003 05:11:00 +0000 |
| Subject: | Re: Re: newbie lost on data import... part 2 | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-29782@lists.php.net to get a copy of this message | ||
jsWalter wrote:
This SQL is generated by my script... INSERT INTO cbs_eps ( eps_id , eps_name , eps_num , eps_air_date ) VALUES ( '5','No Hiding Place','5','1974-01-10'); 'eps_id' is generated from the index ($x) of the array loop the others are retrieved from the tab delimted text file When run from the script, the only thing going in is the epd_id! :( All others are either ZERO or empty (defaults)What kind of columns are you inserting these values into? Are you _sure_ this is the query that's being run by your program, i.e. are you printing it out from within your program and not _assuming_ this is the query? -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ PHP|Architect: A magazine for PHP Professionals – www.phparch.com