// Page Variables
$page_title = "- Weekly Columns";
// Library files
include ("/public/html/internetworkers/lib/page.lib"); // page default variables
include ($page_root."lib/font.lib"); // Font Adjuster
include ($page_root."cgi-bin/pw1.cgi");
include ($page_root."tpl/header.tpl");
include ($page_root."tpl/nav.tpl");
?>
Weekly Columns
Search or Browse Past Columns
$pub_date = date("Y-m-d");
$link = mysql_connect("mysql.ibiblio.org", "komejo", "$dbpw");
$result = mysql_list_tables ("InterNetWorkers");
$tb_names[$i] = mysql_tablename ($result, "0");
if ($article_search != ""){
$serch_col_db_all = "\"%$serch_col_db_all%\"";
$query_string = " != \"\" ";
$query_string2 = " = \"published\" ";
$sSQL = "SELECT * FROM weekly_column ";
$sSQL .= "WHERE row $query_string ";
$sSQL .= "AND auth $query_string2 ";
$sSQL .= "AND published_on <= CURDATE() ";
$sSQL .= "AND author LIKE $serch_col_db_all ";
$sSQL .= "OR title LIKE $serch_col_db_all ";
$sSQL .= "OR sub_title LIKE $serch_col_db_all ";
$sSQL .= "OR text LIKE $serch_col_db_all ";
$sSQL .= "ORDER BY published_on DESC";
$Find_columns = mysql_query ("$sSQL");
//print "mysql_query (\"$sSQL\");";
//echo mysql_errno().": ".mysql_error()."
";
} else {
$query_string = " != \"\" ";
$query_string2 = " = \"published\" ";
$Find_columns = mysql_query ("SELECT * FROM weekly_column WHERE row $query_string AND auth $query_string2 AND published_on <= CURDATE() ORDER BY published_on DESC");
};
// count the number of resumes.
$NumResumes = mysql_num_rows($Find_columns);
// paging
include ($page_root."column/paging.php3");
// return the results of the query into ordered rows and perform any tweaking as needed.
print "
";
while($row = mysql_fetch_array($Find_columns)) {
if ($row[2] != ""){
$row[2] = "$Font $FontColorBodyLink $FontSizeLarge$row[2]";
};
if ($row[3] != ""){
$row[3] = "$Font $FontFace $FontColorBody $FontSizeMedium$row[3]";
};
print "
$Font $FontFace $FontColorBody $FontSizeLarge$row[2]
$row[3]
$Font $FontColorBody $FontSizeSmall by $row[1], $Font $FontFace $FontColorBody $FontSizeSmall $row[5]
$Font $FontFace $FontColorBody $FontSizeMedium\"$row[4]\"
";
print "
";
};
mysql_close ($link);
?>
include ($page_root."tpl/footer.tpl");
?>