[Durakken]

Hi i need a quick tutorial for formatting something import into MySQL from either .txt and/or open office

there are 12 fields. All the fields, as far as I know, are alphanumeric, but there is 1 or 2 that might need an extra 0 that needs to be able to be left out.

Also as far as I know there will be no mathematics used on this, just a read and list those items that have the term listed in their fields.

I don't know any information needed to help to answer this question as I have not ever used mySQL manually or PHP with mySQL or seriously...

Also the reason I am asking ad not "looking' for the answer through tutorials is because i really don't have the time to try figure it out like that apparently (don't know why that's the case) so please could you show or provide a link to a clear tutorial on this?

[ruteckycs]

Is it a CSV file?
I posted code here for importing from a CSV look at the newest posts list.

[Durakken]

I can make the file csv, but the file type is default xlr. I don't know how well that converts...

also can't find the psot you are talking about.

[ruteckycs]

http://www.hotscripts.com/forums/php...nto-mysql.html

[Durakken]

Ok so this is the file... Now to use this do i have to independantly set up the table and fields, or will this create that?

also, any special meaning behind the array and the skip in the array from 4 to 8 in this line "$Phone=$line_of_text[8];"?

and do i load this up to my webhost, load up the file i want converted and then bring up the url? or do i have to do something else?

PHP Code:

<?PHP





mysql_connect("localhost", "Database", "Pasword") or die(mysql_error());

mysql_select_db("Table") or die(mysql_error());



$file_handle = fopen("MD.csv", "r");



while (!feof($file_handle) ) {



$line_of_text = fgetcsv($file_handle, 1024);



print $line_of_text[0] ."<BR>";



$Name=$line_of_text[0];

$Street=$line_of_text[1];

$City=$line_of_text[2];

$State=$line_of_text[3];

$Zipcode=$line_of_text[4];

$Phone=$line_of_text[8];



mysql_query("INSERT INTO Business 

(Name,Street,City,State,Zipcode,Phone) VALUES('$Name','$Street','$City','$State','$Zipcode','$Phone') "); 







}



fclose($file_handle);



?>