HI ALL
THIS IS SQL STATMENT DOS NOT WORK WITH PHP BUT IT IS WORKING WITH Microsoft Office Access 2003 QUERY ANY ONE HELP ME PLEASE
echo " “;
echo " NON”;
$sql = “SELECT DISTINCT student.sunbject, subject_num.name, time_table.techer
FROM (student LEFT JOIN subject_num ON student.sunbject = subject_num.num) INNER JOIN time_table ON student.branch = time_table.pranch
WHERE (((time_table.techer)=’$x’ ))
ORDER BY time_table.techer”;
$result=mysql_query($sql);
while($row=mysql_fetch_row($result))
{
echo “$row[1]”;
}