|
";
$DBhost = "203.170.86.89";
$DBuser = "austral3_casso";
$DBpass = "casso1";
$DBName = "austral3_mag";
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");
@mysql_select_db("$DBName") or die("Unable to select database $DBName");
$result = mysql_query($sqlquery) or die ("Could not read data because ".mysql_error());
$numArticles = mysql_num_rows($result);
$endRecord = $_SESSION['page'] * 10;
$startRecord = $endRecord - 10;
if (mysql_num_rows($result)) {
$articleCount = 1;
$qry = mysql_data_seek($result, $startRecord);
while ($articleCount <= 10) {
$qry = mysql_fetch_array($result);
if ($qry) {
$newText = $qry[text];
$newText = preg_replace('#().*?()#', '$1$2', $newText);
$newText = preg_replace('#().*?()#', '$1$2', $newText);
$newText = str_replace("", "", $newText);
$newText = str_replace("", "", $newText);
$newText = str_replace("", "", $newText);
$newText = str_replace("", "", $newText);
$newText = str_replace("", "", $newText);
$newText = str_replace("", "", $newText);
$shortText = substr($newText, 0, 360);
$theDate = $qry[date];
$theDay = substr($theDate, 6, 2);
$theMonth = substr($theDate, 4, 2);
$theYear = substr($theDate, 0, 4);
switch ($theMonth) {
case 1:
$newMonth = "January";
break;
case 2:
$newMonth = "February";
break;
case 3:
$newMonth = "March";
break;
case 4:
$newMonth = "April";
break;
case 5:
$newMonth = "May";
break;
case 6:
$newMonth = "June";
break;
case 7:
$newMonth = "July";
break;
case 8:
$newMonth = "August";
break;
case 9:
$newMonth = "September";
break;
case 10:
$newMonth = "October";
break;
case 11:
$newMonth = "November";
break;
case 12:
$newMonth = "December";
break;
}
print " |
