Please help, I want to connect two tables in mysql

Show you tables structures, and explain what the result should look like.

I'm guessing that what you are looking for are JOINS? See 13.2.9.2. JOIN Syntax in the MySQL manual for all the details on how that works.

If you're new to this concept, the manual entry is probably not going to be very helpful. You may want to Google for some tutorials that describe this in a less technical way. This one, for example, is very good.
Understanding JOINs in MySQL and Other Relational Databases

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.