thank you, im glad ive been able to help.
you could probably write a little script to go thru that text and format each line and insert it into the database.
it looks to be tab delimited so if you want a few functions that might get the job done, here is a list:
[man]file[/man] - reads a file into an array, each line gets an array index
[man]explode[/man] - splits up a string by a character. you could explode by a tab to get each part of a line into a variable
[man]list[/man] - useful in combination with explode
[man]fgetcsv[/man] - an alternative to the explode function
[man]foreach[/man] - useful to loop thru an array.
another note: in php, a tab character (since it is not really viewable) is represented by a \t
heres what the program may do.
read the text file into the array.
iterate over each line, parse the line assigning each portion of the line to the appropriate variable ($name, $gender...)
formulate a mysql insert query
insert the data.
move on to the next line
continue until you reach end of array
i suppose thats enough homework to keep you busy for at least half day 😉
