News system
Posted: Tue Oct 04, 2005 4:50 am
feyd | Please use
feyd | Please use
Code: Select all
andCode: Select all
tags where appropriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]
I got a news system, and i want to display first news with picture and short text , and below first news i want only title from other news,
is there some function that can do that. Here's the code, please helpCode: Select all
<?php
include("./admin/connect.php");
$sql= "SELECT * FROM vijesti ORDER BY id desc LIMIT 5";
$result= mysql_query($sql,$connect);
while ($newArray = mysql_fetch_array($result)) {
$id = $newArray['id'];
$dan = $newArray['dan'];
$mjesec = $newArray['mjesec'];
$godina = $newArray['godina'];
$sat = $newArray['sat'];
$minute=$newArray['minute'];
$danob = $newArray['danob'] ;
$naslov = $newArray['naslov'];
$vijest = $newArray['vijest'];
$dslika=$newArray['dslika'];
$slikad=$newArray['slikad'];
$slika=$newArray['slika'];
$slikav=$newArray['slikav'];
?>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="5">
<tr>
<th align="left"> <?php echo "$naslov"?></th>
</tr>
<tr>
<td colspan="2" align="center" valign="top"><div align="left">
<table width="85" border="0" align="left" cellpadding="0">
<tr>
<td align="left" valign="top" >
<?php
If( $slika AND $slikav){
?>
<?php echo "<a href=\"./opsirnije.php?id=$newArray[id]\"> <img src=\"./images/vijesti/male/$slika\" border='1' width='80' height='60' ></a>";?>
<?php }
If( $slika AND ! $slikav){
?>
<?php echo" <a href=\"./opsirnije.php?id=$newArray[id]\"><img src=\"./images/vijesti/male/$slika\" border='1' width='80' height='60'></a>";?>
<?php }
If( ! $slika AND $slikad){
?>
<?php echo"<a href=\"./opsirnije.php?id=$newArray[id]\"><img src=\"./images/vijesti/default/$slikad\" border='1' width='80' height='60' ></a>";?>
<?php }
If($dslika AND ! $slikad AND ! $slika){
?>
<?php echo"<a href=\"./opsirnije.php?id=$newArray[id]\"><img src=\"./images/vijesti/gifs/$dslika\" border='1' width='80' height='60' ></a>";?>
<?php } ?>
</td>
</tr>
</table>
<?php echo ("$vijest");?> <?php echo "<a href=\"./opsirnije.php?id=$newArray[id]\"><img src=\"/gifs/opsirnije_54.gif\" border='0' ></a>";?>
</td>
</tr>
<tr>
<td>
</td>
</tr>
<td>
</td>
<?php
$sql = "UPDATE vijesti SET brojac=brojac+1".
"where id=$id";
If (mysql_query(sql)) {}
?>
<?php
$dan2 = date("d");
$mjesec2 = date("m");
$godina2 = date("Y");
$sat2 = date("H");
$minute2 = date("i");
$result = mysql_query(
"SELECT id, naslov, danob, mjesecob, godob, satob, minob, obodma from vijesti ORDER BY id DESC LIMIT 10");
If ($result) {
while ( $row = mysql_fetch_array($result) ) {
$naslov = ($row["naslov"]) ;
$id = ($row["id"]) ;
$danob = ($row["danob"]) ;
$mjesecob = ($row["mjesecob"]) ;
$godob = ($row["godob"]) ;
$satob = ($row["satob"]) ;
$minob = ($row["minob"]) ;
$obodma = ($row["obodma"]) ;
$brojob = $godob . $mjesecob . $danob . $satob . $minob;
$brojsad = $godina2 . $mjesec2 . $dan2 . $sat2 . $minute2;
If($brojob <= $brojsad OR $obodma == '1'){ ?>
<tr>
<td class="txtnaslov2"><?php echo"<a href='opsirnije.php?id=$row[id]'>";?>
<?php echo($naslov); ?>
</a></td>
</tr>
<?php }}}?>
<tr>
<td></td>
</tr>
<tr>
<td class="header" height="25" valign="bottom"></td>
</tr>
</table>
</td>
</tr>
</table>
<?php } ?>
<?php
@mysql_close($connect);
?>feyd | Please use
Code: Select all
andCode: Select all
tags where appropriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]