$miseccion

"; $sql="SELECT * FROM news WHERE Section='$miseccion' and Publish='Y' ORDER BY Date DESC "; $mysql_result=mysql_query($sql); $num_rows=mysql_num_rows($mysql_result); if ($num_rows == 0) { echo ""; echo "No articles available. Please try again later.

Thank you!


"; } else { while ($row=mysql_fetch_array($mysql_result)) { $ID=$row["ID"]; $date=$row["Date"]; # date substring process $year=substr($date, 0,4); $mo=substr($date, 5,2); $day=substr($date, 8,2); $mydate="$day/$mo/$year"; $include_date=$row["Include_date"]; $title=$row["Title"]; $title=str_replace("\n","
",$title); $title=stripslashes($title); $brief=$row["Brief"]; $brief=str_replace("\n","
",$brief); $brief=stripslashes($brief); $photolink =$row["Photolink"]; $full = $row["Full"]; echo "
$title

"; if ($photolink !== "") { echo "";} if ($include_date=="Y") {echo "$mydate - ";} echo "$brief
"; if ($full !=="") { echo "[ + ]"; } echo "


"; } } mysql_close($connection); ?>