asi esta la funcion
function parse_bd($countrySelect, $query, $jobLocation, $max)
{
global $lang, $jobLocation, $jobSelect, $countrySelect, $keyword, $refineKeyword;
# // \\ #
$jobLocation = trim($jobLocation);
$query = trim($query);
//
$querys = isset($jobLocation) ? isset($query) ? $query.' ' .$jobLocation : $jobLocation : $query;
$pages = mysql_fetch_assoc($peig = mysql_query('SELECT COUNT(codigo) AS total '.$cueri = ' FROM '._table_.' WHERE MATCH(title) AGAINST(\''.mysql_real_escape_string($querys).'\' ) ORDER BY death DESC'));
if($pages['total'] == 0) {return 'Empty';} else {
//
$data['pages'] = paginacion($pages['total'], 11);
if($data['pages']['limite'] == 1) {return 'Nada';}
//
echo str_replace(array('{total}', '{page}', '{totalp}'), array($pages['total'], $data['pages']['page'], $data['pages']['totalp']), $lang['busquedas_encontradas']);
//echo 'Se han encontrado '.$pages['total'].' resultados - Página '.$data['pages']['page'].' de '.$data['pages']['totalp'];
//
//register_mysearches($query, $jobLocation, $jobSelect, $pages['total']);
//
$query = mysql_query($f = 'SELECT * '.$cueri.' LIMIT '.$data['pages']['limit']);
while($data['info'] = mysql_fetch_assoc($query))
{
$descc = substr(trim($data['info']['description']), 0, 3);
if($descc == 'JoS' || empty($data['info']['description']))
{
$extrade = 'rel="nofollow" target="_blank"';
$link_new_data = $data['info']['link'];
}
//
$slip = ($descc == 'JoS') ? 3 : 0;
$data['info']['description'] = substr(strip_tags($data['info']['description']), $slip, 400).'...';
//
include('layout/search-results.php');
unset($link_new_data, $extrade);
//
++$i;
}
//
$url = _siteurl.'/search-jobs.php?seo_url1='.$lang['seo_url1'].'&jobLocation='.$jobLocation.'&jobSelect='.$jobSelect.'&countrySelect='.$countrySelect.'&keyword='.$keyword.'&workExp='.$jobtype.'&refineKeyword='.$refineKeyword;
//--\\
if($data['pages']['prev'] > 0) echo '<a href="'.$url.'&page='.$data['pages']['prev'].'">'.$lang['busquedas_paginador2'].'</a> ';
if(mysql_num_rows($query) > 10 && $data['pages']['next'] <= 100) echo '<a href="'.$url.'&page='.$data['pages']['next'].'">'.$lang['busquedas_paginador'].'</a>';
}
}
function paginacion($total, $max = 10){
// PÁGINA ACTUAL
$pages['page'] = empty($_GET['page']) ? 1 : abs((int)$_GET['page']);
// Nº PAGINAS
//fixed by Cicklow
$tmp_p = ceil($total / $max);
$pages['totalp'] = iff($tmp_p>100,100,$tmp_p);
// ANTERIOR
$pages['prev'] = ($pages['page'] > 0) ? $pages['page'] - 1 : 0;
// SIGUIENTE
$pages['next'] = ($next <= $pages['totalp']) ? $pages['page'] + 1 : 0;
// LIMITE BD
$pages['limit'] = (($pages['page'] - 1) * $max).','.$max;
//fixed by Cicklow
$pages['limite'] = 0;
if($pages['limit']>1089){
$pages['limite'] = 1;
$pages['limit'] = 1089;
$pages['totalp'] = 100;
$pages['page'] = 100;
}
return $pages;
}
function iff($A,$B,$C){
if($A) return $B; else return $C;
}
Insertar CODE, HTML o PHP:
$pages = mysql_fetch_assoc(mysql_query("SELECT COUNT(codigo) AS total ".$cueri." FROM "._table_." WHERE MATCH(title) AGAINST('".mysql_real_escape_string($querys)."' ) ORDER BY death DESC LIMIT 0,1000"));
Por otro lado: _table_ es una variable definida??¿¿ porke sino le falta el $
Por otro lado tu consulta es mal armada... tiene errores... por eso se muere y ya te he dicho antes... ponele la opcion de mostrar errores al php sino una pagina en blanco es de adivinos.
