|
$artId = $_GET['article_id'];
mysql_connect($dbHost,$username,$password);
@mysql_select_db($database_art) or die( "Unable to select database");
//getting top story
$query = "SELECT id, title, title_sub, author, pic_1, pic_1_cap, pic_2, pic_2_cap, content, category FROM `art_0111` WHERE id =$artId";
$result = mysql_query($query);
$num = mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$artId = mysql_result($result, $i, "id");
$artTitle = mysql_result($result, $i, "title");
$artTitleSub = mysql_result($result, $i, "title_sub");
$artAuthor = mysql_result($result, $i, "author");
$artContent = mysql_result($result, $i, "content");
$artPic_1 = mysql_result($result, $i, "pic_1");
$artPic_1_cap = mysql_result($result, $i, "pic_1_cap");
$artPic_2 = mysql_result($result, $i, "pic_2");
$artPic_2_cap = mysql_result($result, $i, "pic_2_cap");
?>
echo"$artTitle
$artTitleSub ";
if (!empty($artAuthor)){
echo"
By: $artAuthor
";
}
?>
if (!empty($artPic_1)){?>
/ echo "$artPic_1";?>.jpg" class="img">
if (!empty($artPic_1_cap)){?>
Above: echo "$artPic_1_cap";?>
}?>
if (!empty($artPic_2)){?>
next photo
}?>
} ?>
if (!empty($artPic_2)){?>
/ echo "$artPic_2";?>.jpg" class="img">
if (!empty($artPic_2_cap)){?>
Above: echo "$artPic_2_cap";?>
}?>
prev photo
}
?>
echo "$artContent"; ?>
|
$i++;
}
?>
back to news
|
|
|
|
|
|
|
|