Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Page 3 of 3 FirstFirst 123
Results 31 to 38 of 38

Thread: My sql

  1. #31
    Regular Coder
    Join Date
    Aug 2013
    Posts
    191
    Thanks
    11
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Fou-Lu View Post
    (⌐■_■)
    You need to post the document that you've shown a screenshot of here: http://www.codingforums.com/attachme...my-sql-999.jpg
    The only way that i can post this documents is to do attachments like this.On 999.jpg you can see data what is in there and is not too many information's that you can make same file in minutes.
    Attached Files Attached Files

  2. #32
    Regular Coder Linux_Sage's Avatar
    Join Date
    Mar 2014
    Location
    Sterling,VA
    Posts
    106
    Thanks
    0
    Thanked 10 Times in 10 Posts
    I tried to reply before but I guess the spam filter snagged me when I tried to put real links inside my example... anyway. Try to keep in this form:

    Code:
    title,descrption,url,keywords
    Some title,A descrption,URL here,keywords go here
    Some title,A descrption,URL here,keywords go here
    Some title,A descrption,URL here,keywords go here
    Some title,A descrption,URL here,keywords go here
    That way everything belongs in it's own column and you can use Excel or whatever to sort each one however you want. I have no idea if this was your problem though.

    Your CSV file looked like it had some weird format. It was using semicolons instead yet they were everywhere.

  3. #33
    Regular Coder
    Join Date
    Aug 2013
    Posts
    191
    Thanks
    11
    Thanked 0 Times in 0 Posts

    my sql

    Linux_Sage can we talk over the skype.

  4. #34
    Regular Coder
    Join Date
    Aug 2013
    Posts
    191
    Thanks
    11
    Thanked 0 Times in 0 Posts

    My sql

    If this project will work and make some money i am ready to donate that money here.

  5. #35
    Regular Coder Linux_Sage's Avatar
    Join Date
    Mar 2014
    Location
    Sterling,VA
    Posts
    106
    Thanks
    0
    Thanked 10 Times in 10 Posts
    I don't Skype with strangers. Is there a problem with what I provided? What's the issue now?

  6. #36
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,987
    Thanks
    4
    Thanked 2,660 Times in 2,629 Posts
    Yep, effectively you simply have to clean up the document you have here.
    Each of these semi-colons will be interpreted as a property from a csv perspective. If you want to have 4 properties, then there should only be 4 semi-colons. You have 12 from the looks of it which would indicate you also need 12 otherwise. Remove the first line as well.
    PHP Code:
    header('HTTP/1.1 420 Enhance Your Calm'); 

  7. #37
    Regular Coder
    Join Date
    Aug 2013
    Posts
    191
    Thanks
    11
    Thanked 0 Times in 0 Posts

    My sql

    Linux let become friends, this is project which everyone can get
    benefit i am working so long on this project i need just little be more to be done and make us happy.

    title,descrption,url,keywords
    Some title,A descrption,URL here,keywords go here
    Some title,A descrption,URL here,keywords go here
    Some title,A descrption,URL here,keywords go here
    Some title,A descrption,URL here,keywords go here

    Where i have to paste this code in csv or datebase.

  8. #38
    New to the CF scene
    Join Date
    Apr 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Well you have pritty basic questions. I think you should check an sql tutorial for more clues. You might find it helpful. It helped me at the beginning too


 
Page 3 of 3 FirstFirst 123

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •