include ('gestion/connect.inc');
include ('gestion/classes.php');
require ("gestion/library.inc");
require ("gestion/ps_pagination_dms_".$sLang.".php");
require ("dic_".$sLang.".php");
?>
include ('header_'.$sLang.'.php');
?>
############################################################################################################
##query
$sql = "SELECT interviews.interview_id, interviews.title_".$sLang.", interviews.interview_".$sLang.", interviews.artist_id, interviews.author_id, DATE_FORMAT(interviews.date,'%d-%m-%Y'), artists.name, artists.surname ".
"FROM interviews LEFT JOIN artists ON artists.artist_id=interviews.artist_id ".
"WHERE interviews.title_".$sLang." !='' AND (interviews.pendiente='S' OR interviews.pendiente='D' OR interviews.pendiente='B') ".
"ORDER BY interviews.date DESC";
//echo $sql;
$pager = new PS_Pagination($conn, $sql, 20, 10, "nLang=$nLang&buscar=$buscar&accion=interview");
/*
* Enable debugging if you want o view query errors
*/
$pager->setDebug(true);
/*
* The paginate() function returns a mysql result set
* or false if no rows are returned by the query
*/
$rs = $pager->paginate();
if(!$rs) die(mysql_error());
while($row = mysql_fetch_row($rs)) {
print "".$row[1]."";
print " | $d_interview_with: ".$row[6]." |
";
}
?>
print "
";
echo $pager->renderFullNav();
print "
";
?>
include ('footer_'.$sLang.'.php');
?>