inner join php mysql code example

Example 1: inner join mysql

SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;

Example 2: inner join in php

<?php
SELECT t1.*, t2.subject, t2.color FROM questionoftheday t1 INNER JOIN subject t2 
ON t1.sid = t2.ID WHERE t1.qdate='$newrd' AND t1.status='1' ORDER BY t1.ID DESC
?>

Tags:

Sql Example

Related