inner join in php mysql example
Example: 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
?><?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
?>