Re: newbie lost on data import... part 2
| From: | jsWalter | Date: | Sun, 10 Aug 2003 05:07:40 +0000 |
| Subject: | Re: newbie lost on data import... part 2 | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-29781@lists.php.net to get a copy of this message | ||
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)
Now, if I take this same SQL and drop into phpmyAdmin all the data is
inserted!
All the fields!
What the h#@& and I doing wrong! ????????????
The only thing Ican think of is varialbe typing.
Walter