blanktarget Posted November 4, 2003 Share Posted November 4, 2003 I can\'t get this text fle imported. I have over one hundreditems I want into one field, the table has two fields, an auto_increm id field and the other field which is varchar data. I get all manner of errors inserting them. $sql= \"INSERT INTO table (\'column_2\') VALUES (\'item_1,\')\"; \"INSERT INTO table (\'column_2\') VALUES (\'item_2,)\"; etc 100 times. if (@mysql_query($sql)) { echo(\"<h4 align=\'center\'>Your listing has been added</h4><br>\"); } else { echo(\"<h4>Error the adding the listing: \" . mysql_error() . \"</h4>\"); } what is wrong? Link to comment https://forums.phpfreaks.com/topic/1294-importing-a-text-file/ Share on other sites More sharing options...
shivabharat Posted November 4, 2003 Share Posted November 4, 2003 Have a look at this posting http://www.phpfreaks.com/forums/viewtopic....&highlight=load Link to comment https://forums.phpfreaks.com/topic/1294-importing-a-text-file/#findComment-4296 Share on other sites More sharing options...
blanktarget Posted November 4, 2003 Author Share Posted November 4, 2003 thanks Link to comment https://forums.phpfreaks.com/topic/1294-importing-a-text-file/#findComment-4300 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.