[SOLVED] SPOT THE ERROR

[teng84]

there is an error in this code

    if (isset($_GET['sorted_by'])){
	switch($_GET['sorted_by']){
		case "id":
			$sorted_by = " ORDER BY GEN_LIST.LISTINGID ";
			break;
		case"title":
			$sorted_by = " ORDER BY GEN_LIST.TITLE ";
			break;
		case"description":
			$sorted_by = " ORDER BY GEN_LIST.SHORTDESC ";
			break;
		case"category":
			$sorted_by = " ORDER BY GEN_LIST.CATEGORY ";
			break;
		case"subcategory":
			$sorted_by = " ORDER BY GEN_LIST.SUBCATEGORY ";
			break;
		case"posted by":
			$sorted_by = " ORDER BY GEN_LIST.USER ";
			break;
		case"date posted":
			$sorted_by = " ORDER BY GEN_LIST.DATEADDED "
			break;
		case"active":
			$sorted_by = " ORDER BY GEN_LIST.RK, GEN_LIST.DATEADDED  ";
			break;
		case"inactive":
			$sorted_by = " ORDER BY GEN_LIST.RK DESC, GEN_LIST.DATEADDED  ";
			break;
		default:
			$sorted_by = $def_sort;
			break;
	}//end switch
}

[kenrbnsn]

Missing semi-colon on

<?php
$sorted_by = " ORDER BY GEN_LIST.DATEADDED "
?>

 

Ken

[teng84]

haha thanx...

 

i cant turn error reporting its live.

 

[kenrbnsn]

When you're debugging, you need to turn error reporting on or debug on a test server.

 

Ken