Categories and MySQL



  • Hey, everybody, it's hard. I've got to make categories, and I don't know what's right. Massives? Here's the table. category and is the table topic, fields:

    id author title tags date text  img cat
    

    cat - it is indicated as if id category is in the tables category♪ a category contained

    id name meta_k  meta_d
    

    I don't even know how to do this? Something like that in the table. topic Field cat contains 3, the table category We'll take the 3rd, there's a category name.



  • Read it. JOIN in mysql. The request shall, in general, be a form:

    SELECT * FROM topic t JOIN category c ON t.cat = category.id
    



Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2