Need to Create Database Table from Text Feed!

Discussion in 'MySQL' started by red-sky, Feb 17, 2009.

  1. #1
    I am completely new to MySQL so if this seems like a newb question try not to be too harsh. Basically I have a Text Feed delimited by "|" that I want to build a table with on MySQL.

    I'm hoping that I can write a query that will allow me to generate this table, allowing me to split by the delimiter and give an appropriate name to each coloumn as I want to be able to filter my searches by ascending column **blah blah when Im calling it from my website.

    Can this be done? I have 0 experience with MySQL so im hoping to learn something from this too if anyone can help

    Thanks in advance!
     
    red-sky, Feb 17, 2009 IP
  2. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #2
    You'll need explode() and fread() and fwrite() functions
     
    crivion, Feb 17, 2009 IP