$db_host = "localhost";
$db_user = "catwalk";
$db_pass = "buffalo8";
$db_db = "catwalkdb";
$connID = @mysql_pconnect($db_host, $db_user, $db_pass) or die("Keine Verbindung!");
@mysql_select_db($db_db, $connID) or die($errorMsg[2]);
?>
|
Catwalk American Tabledance |
|
|
|
Party
$sqlQuery1 = "SELECT * FROM party_name ORDER BY name";
$result1 = @mysql_query($sqlQuery1, $connID) or die($errorMsg[3]);
$num_rows1 = mysql_num_rows($result1);
for($i = 0; $i < $num_rows1; $i++) {
$array = mysql_fetch_array($result1);
$name = $array['name'];
$idname = $array['idname'];
$sqlQuery = "SELECT * FROM party_pics WHERE nameid = '$idname' LIMIT 2";
$result = @mysql_query($sqlQuery, $connID) or die($errorMsg[3]);
$num_rows = mysql_num_rows($result);
if($num_rows > "0") {
for($j = 0; $j < $num_rows; $j++) {
$data = mysql_fetch_array($result);
$bild[$j] = $data['bildname'];
}
$image = "bilder_party/".$bild[0];
$size = getimagesize("$image");
$height = $size[1];
$width = $size[0];
if ($width > 200) {
$width = 200;
$percent = ($size[0] / $width);
$height = ($size[1] / $percent);
} if ($height > 250) {
$height = 250;
$percent = ($size[1] / $height);
$width = ($size[0] / $percent);
}
?>
echo $name; ?> |
|
|
|
}
if($num_rows > "1") {
$image = "bilder_party/".$bild[1];
$size = getimagesize("$image");
$height = $size[1];
$width = $size[0];
if ($width > 200) {
$width = 200;
$percent = ($size[0] / $width);
$height = ($size[1] / $percent);
} if ($height > 250) {
$height = 250;
$percent = ($size[1] / $height);
$width = ($size[0] / $percent);
}
?>
|
|
|
|
|
} ?>
|
|
|
} ?>
|
www.Catwalkbb.de |
|
|