[thelist] Q on mySQL and PHP...

Anthony Baratta Anthony at Baratta.com
Fri Aug 8 23:04:44 CDT 2003

At 07:53 PM 8/8/2003, jsWalter wrote:
>I have a 1400 line text file. TAB delimited.
>    Field         Type Attributes   Null   Default
>    ---------------------------------------------------
>    eps_id        tinyint(4)        No      0
>    cat_id        tinyint(4)        Yes     NULL

First off, don't use TinyInt. That is fixed at 127. You can't have 1400 
rows with only 127 ids.

Second, are you printing your SQL string to the browser so you can see what 
you are attempting to put into the database?? If so, can we see that?

Anthony Baratta
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."

More information about the thelist mailing list