Re: [PHP-DB] Re: newbie lost on data import... part 2

[jsWalter]

"John W. Holmes" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> jsWalter wrote:


> What kind of columns are you inserting these values into?

eps_id int(11)Yes 0
eps_name varchar(100) Yes NULL
eps_num int(11)   Yes NULL
eps_air_date date Yes -00-00


> 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?

Yes, the SQL I posted was copied from the text generated and viewed on the
browser

Thanks for your help.

Walter





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

Re: [PHP-DB] Re: newbie lost on data import... part 2

[John W. Holmes]

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