Problems adding data in database

Discussion in 'MySQL' started by gerta, Dec 28, 2008.

  1. #1
    I've made an admin page where I put in some data (like object name, category, subcategory, photo etc.) and with a script php+mysql I actually succeed to add this data in my database, but after that when i do select by the name of the object i just added, nothing is returned! The strange thing is that this happens only if I select the name, but with all other data it works!
    How is this possible when I can see that this name is in database, but it doesn't show when it's selected??:confused:
    Can this do with the fact that the text in my database is in latin1_swedish_ci collation ??
     
    gerta, Dec 28, 2008 IP
  2. javaongsan

    javaongsan Well-Known Member

    Messages:
    1,054
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    128
    #2
    try selecting using like
    like '%name%' if this shows then the name check for space or mispells
     
    javaongsan, Dec 28, 2008 IP
  3. gerta

    gerta Peon

    Messages:
    14
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thanks I fixed it now :)
     
    gerta, Dec 29, 2008 IP