Is there a reason why this php code:
$result=mysql_query($query);
while ($query_data=mysql_fetch_array($result)) {
won't work with this SELECT query?
$query="SELECT request.id, request.date, request.type, request.status,
faculty.f_name, faculty.l_name, action.id, faculty.id FROM request INNER
JOIN faculty ON request.requested_by=faculty.id LEFT JOIN request ON
action.request_id=request.id";
Any ideas?
Thanx
$result=mysql_query($query);
while ($query_data=mysql_fetch_array($result)) {
won't work with this SELECT query?
$query="SELECT request.id, request.date, request.type, request.status,
faculty.f_name, faculty.l_name, action.id, faculty.id FROM request INNER
JOIN faculty ON request.requested_by=faculty.id LEFT JOIN request ON
action.request_id=request.id";
Any ideas?
Thanx