<?php
$title = "Nos liens, conseil informatique & agence web 7ici. partenaires annuaires";
$description = "Partenaires services Internet 7ici, liens a visiter et annuaires";
$css = '<link rel="stylesheet" type="text/css" href="home.css" />';
define("_DB_HOST",'localhost');
define("_DB_USER",'7ici');
define("_DB_PASS",'sevenroadtrip');
define("_DB_NAME",'7ici');
define("_ROOT",'/usr/data1/website/7ici.biz/www');

$mysql_connection = ($GLOBALS["___mysqli_ston"] = mysqli_connect('localhost', '7ici', 'sevenroadtrip')) or die(mysqli_error($GLOBALS["___mysqli_ston"]));

include('header.php');
include('top.php');
      echo "
<br><br>
<div align='center'>
<TABLE WIDTH='750' BORDER='0' CELLPADDING='0' CELLSPACING='0'>
          
								";
$WebRoot = _ROOT;
$result=((mysqli_query($GLOBALS["___mysqli_ston"], "USE " . constant('_DB_NAME'))) ? mysqli_query($GLOBALS["___mysqli_ston"], "SELECT * FROM LinkCategory ORDER BY Ordre") : false);
while ($row  =  mysqli_fetch_array($result)) {
if ( $row[CategoryFR] == "" ) continue;
echo "
				<TR>
          <TD CLASS='parttitre' height='2' width=300><strong>
            ".$row[CategoryFR]."
						</strong>
          </TD>
        </TR>
				 <TR>
          <TD align=left CLASS='parttexte'>
            <BLOCKQUOTE>
                <P>
";			
			$result2=((mysqli_query($GLOBALS["___mysqli_ston"], "USE " . constant('_DB_NAME'))) ? mysqli_query($GLOBALS["___mysqli_ston"], "SELECT * FROM Link WHERE CategoryID='".$row[CategoryID]."' ORDER BY LinkFR") : false);
			
			while ($row2  =  mysqli_fetch_array($result2)) {
				if ( $row2[LinkFR] == "" ) continue;
$row2[UrlLogo] = stripslashes($row2[UrlLogo]);
$row2[LinkFR] = stripslashes($row2[LinkFR]);
//$row2[LinkEN] = stripslashes($row2[LinkEN]);
$row2[DescriptionFR] = stripslashes($row2[DescriptionFR]);
//$row2[DescriptionEN] = stripslashes($row2[DescriptionEN]);
				$string = "";
				if ( $row2[UrlLogo] != "" ){
					 $string = $row2[UrlLogo];
				} elseif ( file_exists("$WebRoot/images_liens/".$row2[LinkID].".jpg")) {
					 $string = "<a class='lien-texte' href='".$row2[Url]."' target='_blank'><img src='/images_liens/".$row2[LinkID].".jpg' border='0'></A>";
				} elseif ( file_exists("$WebRoot/images_liens/".$row2[LinkID].".gif")) {
					 $string = "<a class='lien-texte' href='".$row2[Url]."' target='_blank'><img src='/images_liens/".$row2[LinkID].".gif' border='0'></A>";
				}
				 echo "<table width=750 border=0 cellpadding=0 cellspacing=0><tr valign=middle><td CLASS=\"parttexte\" align=left width=300>
				 • <a class='lien-texte' href='".$row2[Url]."' target='_blank'>".$row2[LinkFR]."</A><br>
				 ".$row2[DescriptionFR]."
				 </td><td align=right>$string</td>
				 </tr>
				 </table><br>";
      }
			
echo "
            </BLOCKQUOTE><BR>
          </TD>
        </TR>
			";
}

echo "</TABLE></div>";

include('footer.php');
?>