I am working on a website with a custom CMS built into it and on the index page of the site I am pulling two different sets of information from the database and there are read more links that I would like to have link up to two different pages. I am assuming that i would need some sort of if then statement to do so but not sure how to go about that.
Below is the code that I currently have in place:
<div class="indMidRgt">
<h3 class="newsEvtsHdr"><i>News & Events</i></h3>
<script language="javascript">
$(document).ready(function(){
$("#myController").jFlow({
slides: "#mySlides",
controller: ".jFlowControl", // must be class, use . sign
slideWrapper : "#jFlowSlide", // must be id, use # sign
selectedWrapper: "jFlowSelected", // just pure text, no sign
width: "400px",
height: "225px",
duration: 300,
prev: ".jFlowPrev", // must be class, use . sign
next: ".jFlowNext" // must be class, use . sign
});
});
</script>
<div id="mySlides">
<?
$dbquery = "select * from tblnews LEFT JOIN tblcategory ON (tblcategory.categoryid=tblnews.categoryid) order by enter_date desc " ;
//echo($dbquery);
$result = mysql_db_query($dbname,$dbquery); if(mysql_error()!=""){echo mysql_error();}
if(mysql_num_rows($result)> 0)
{
$intTotal = mysql_num_rows($result);
$intTotal = intval(($intTotal / 2) + 0.5);
if($intTotal > 7) {$intTotal=7;};
$intCount = 0;
?>
<? while($row = mysql_fetch_array($result)){
$intCount = $intCount + 1;
if ($intCount == 1) {echo("<div><ul class='slider02'>");}
?>
<li>
<? if ($row["newstype"] == "event"){?>
<label><?echo(date("M",strtotime($row["startdate"])))?> <b><?echo(date("d",strtotime($row["startdate"])))?></b></label>
<?}
else {echo("<div class='label1new'></div>");}?>
<div class="slidr02Data">
<h4><?=$row["newstitle"]?></h4>
<? if ($row["startdate"] != "0000-00-00 00:00:00" || $row["enddate"] != "0000-00-00 00:00:00"){?>
<small><?echo(date("M",strtotime($row["startdate"])) . " " .date("d",strtotime($row["startdate"])) . " ". date("Y",strtotime($row["startdate"])))?>
<? if ($row["enddate"] != "0000-00-00 00:00:00"){?>
to <?echo(date("M",strtotime($row["enddate"])) . " " .date("d",strtotime($row["enddate"])) . " ". date("Y",strtotime($row["enddate"])))?> <?}?>
</small>
<?}?>
<p><?=$row["shortdesc"]?></p>
<a href="events.php" title="Read More">Read More ></a>
</div>
</li>
<?
if ($intCount == 2) {
echo("</ul></div>");
$intCount = 0;
}
}
if ($intCount == 1) {echo("</ul></div>");}
?>
<?}?>
</div>
<div id="myController">
<?
for ( $counter = 1; $counter <= $intTotal; $counter += 1) {
echo("<span class='jFlowControl'>".$counter."</span>");
}
?>
<!--<span class="jFlowControl">1</span>
<span class="jFlowControl">2</span>
<span class="jFlowControl">3 </span>
<span class="jFlowControl">4</span>
<span class="jFlowControl">5</span>
<span class="jFlowControl">6</span>
<span class="jFlowControl">7</span>-->
</div>
<div class="slidrBtm">
<a href="news.php" title="more news">more news ></a>
<a href="events.php" title="more events">more events ></a>
</div>
</div>
The area highlighted in green shows up under every new post on the index page, but i need to have it so that if the posting is an event it will go to the events page and if it is a news post it will go to the news page. Any advice or guidance would be much appreciated with this.