Location: PHPKode > projects > Modular Site Manager > htdocs/sotw_man/resize.php
<?php
$db_data = array(
"localhost", 
"vouksh",
"xf3G63Wt",
"vouksh_all",
"site_sotw"
);

$db = mysql_connect($db_data["0"], $db_data["1"], $db_data["2"]) or die("There was a mysql error: "mysql_error());
mysql_select_db($db_data["3"]) or die("There was a mysql error: "mysql_error());
$query = "SELECT * FROM site_sotw DESC LIMIT 1"
$select = mysql_query($query);
//While there's more affiliates, perform this operation each time for each row
while($r = mysql_fetch_array($select)) {
// The file
$image = $r['image'];
$id = $r['id'];
$sitename = $r['site'];
$desc = $r['desc'];
$rating = $r['rating'];
?>
<table width="90%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td>Site Name: <a href="<? echo "$address"; ?>"><? echo $sitename; ?></a> </td>
  </tr>
  <tr>
    <td><img src="<? echo $image; ?>"></td>
  </tr>
  <tr>
    <td><? echo $desc; ?></td>
  </tr>
</table>
<?
mysql_close($dbcnx);
?> 
Return current item: Modular Site Manager