0 )
$query = "UPDATE cercanews SET testo = '".$_POST['search']."' WHERE session_id = '".session_id()."'";
else
$query = "INSERT INTO cercanews(testo, session_id) VALUES('".$_POST['search']."','".session_id()."')";
mysql_query($query, $database) or die(mysql_error());
}
else
{
mysql_select_db($database_database, $database);
$query_rsCerca = "SELECT * FROM cercanews WHERE session_id = '".session_id()."'";
$rsCerca = mysql_query($query_rsCerca, $database) or die(mysql_error());
$row_rsCerca = mysql_fetch_assoc($rsCerca);
$totalRows_rsCerca = mysql_num_rows($rsCerca);
$_POST['search'] = $row_rsCerca['testo'];
}
$colname_rsLingua = "1";
if (isset($_SESSION['idLanguage'])) {
$colname_rsLingua = $_SESSION['idLanguage'];
}
mysql_select_db($database_database, $database);
$query_rsLingua = sprintf("SELECT sitelabels_static.*, sitelabels.* FROM sitelabels_static JOIN sitelabels on sitelabels_static.key_label = sitelabels.id WHERE sitelabels_static.language_label = %s", GetSQLValueString($colname_rsLingua, "int"));
$rsLingua = mysql_query($query_rsLingua, $database) or die(mysql_error());
$row_rsLingua = mysql_fetch_assoc($rsLingua);
$totalRows_rsLingua = mysql_num_rows($rsLingua);
mysql_select_db($database_database, $database);
$query_rsNews = "SELECT news.*, news_details.* FROM news JOIN news_details ON news.id_news = news_details.idnews_newsdetails WHERE language_newsdetails = ".$colname_rsLingua." AND ( titolo_newsdetails LIKE '%".$_POST['search']."%' OR testo_newsdetails LIKE '%".$_POST['search']."%' ) ORDER BY data_news DESC";
$rsNews = mysql_query($query_rsNews, $database) or die(mysql_error());
$row_rsNews = mysql_fetch_assoc($rsNews);
$totalRows_rsNews = mysql_num_rows($rsNews);
// Show Dynamic Thumbnail
$objDynamicThumb1 = new tNG_DynamicThumbnail("", "KT_thumbnail1");
$objDynamicThumb1->setFolder("gallery/news/");
$objDynamicThumb1->setRenameRule("{rsNews.image_news}");
$objDynamicThumb1->setResize(91, 0, true);
$objDynamicThumb1->setWatermark(false);
// Show Dynamic Thumbnail
$objDynamicThumb2 = new tNG_DynamicThumbnail("", "KT_thumbnail2");
$objDynamicThumb2->setFolder("gallery/news/");
$objDynamicThumb2->setRenameRule("{rsNews.image_news}");
$objDynamicThumb2->setResize(91, 0, true);
$objDynamicThumb2->setWatermark(false);
// Trasformare resultSet in Array
$labels = array();
for( $i = 0; $i < $totalRows_rsLingua; $i++ )
{
// Array
$labels[$row_rsLingua['labelname']] = $row_rsLingua['value_label'];
// Go on
$row_rsLingua = mysql_fetch_assoc($rsLingua);
}
?>
::..FNM-MARINE....::::: Marine Diesel Engine :::::::::::.................................................
0 )
{
?>
|
|
|
103 )
$stringa = substr( $row_rsNews['testobreve_newsdetails'], 0, 103 )."...";
else
$stringa = $row_rsNews['testobreve_newsdetails'];
?>
... |
READ MORE > |
|
|
|
|
|
|
|
103 )
$stringa = substr( $row_rsNews['testobreve_newsdetails'], 0, 103 )."...";
else
$stringa = $row_rsNews['testobreve_newsdetails'];
?>
... |
READ MORE > |
|
|
Nessun risultato prodotto |