Re: Re: newbie lost on data import... part 2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux