PHP Classes

JOIN tables

Recommend this page to a friend!

      MySQLi Manager  >  All threads  >  JOIN tables  >  (Un) Subscribe thread alerts  
Subject:JOIN tables
Summary:I need JOIN tables
Messages:2
Author:Rafael M
Date:2016-06-28 14:36:03
 

  1. JOIN tables   Reply   Report abuse  
Picture of Rafael M Rafael M - 2016-06-28 14:36:03
Hi,

How can I do join?
rafael.contact@gmail.com

Regards,
Rafael

  2. Re: JOIN tables   Reply   Report abuse  
Picture of Mohamed Elbahja Mohamed Elbahja - 2016-06-28 15:19:04 - In reply to message 1 from Rafael M
hello

It can be carried out by $db->query()

ex:

$db = new Mysqli_Manager();

$data = $db->query("SELECT posts.post_id,posts.post_title,category.name
FROM posts
INNER JOIN category
ON posts.cate_id=category.cate_id
WHERE ....");


var_dump($data->fetch_assoc());