MySQL PHP Tutorial – Select & Display Data From MySQL Tables




This MySQL PHP tutorial is suitable for beginners as well as advanced MySQL users. In this lesson we mostly cover selecting data from the tables as well as …

Original source


14 responses to “MySQL PHP Tutorial – Select & Display Data From MySQL Tables”

  1. @Clever Techie. Your tutorial is so much helpful. Now i want the items to appear in a grid form say after 4 items a row should be automatically created which will contain another 4 items and and so on. How can i achieve that? Thanks

  2. Hey Clever Techie! Great tutorial and great tutorial series! Your really cover a great deal of detail and make sure the viewer realize where the tricky sections are. And then you clearly explain those tricky sections. Keep up the good work!! Thanks!

  3. Hello,
    I have 5 tables in which I define something with id's and have another table in which I combine that id's in a row. I try to select them with the query below but it works properly but gives me only the first row of the table
    "SELECT anlasma.anlasmaID, fakulte.fakulteAdi, bolum.bolumAdi, koordinator.koordinatorAdi, ulke.ulkeAdi, universite.uniAdi FROM anlasma, fakulte, bolum, koordinator, ulke, universite WHERE anlasma.fakulteID=fakulte.fakulteID AND anlasma.bolumID=bolum.bolumID AND anlasma.koordinatorID=koordinator.koordinatorID AND anlasma.ulkeID=ulke.ulkeID AND anlasma.uniID=universite.uniID"

    Should I use JOIN to get all the results?
    Waiting forward to your respond to that,
    Thanks in advance 🙂

  4. Great video man, definitely subscribed.
    How would you go about then making each title a link to a…movieinfo.php file where the user could view further information about that movie?
    I think that would be a lot of fun.

  5. Is there any way you can help me with my project? I want to make a search bar that I want to link to a database like this. It will be a database about video games. I want the information to be displayed like you've done in this video

Leave a Reply