// Page Variables
$page_title = "- Weekly Column";
// 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 Column
Column Archive
$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_view != ""){
$query_string = " = \"$article_view\" ";
$query_string2 = " = \"published\" ";
$Find_jobs = mysql_query ("SELECT * FROM weekly_column WHERE row $query_string AND auth $query_string2 AND published_on <= CURDATE() ORDER BY published_on DESC LIMIT 1");
} else {
$query_string = " != \"\" ";
$query_string2 = " = \"published\" ";
$Find_jobs = mysql_query ("SELECT * FROM weekly_column WHERE row $query_string AND auth $query_string2 AND published_on <= CURDATE() ORDER BY published_on DESC LIMIT 1");
};
//echo mysql_errno().": ".mysql_error()."
";
//print "SELECT * FROM weekly_column WHERE row $query_string AND auth $query_string2 AND MONTH(published_on) = 5 ORDER BY published_on DESC LIMIT 1";
// return the results of the query into ordered rows and perform any tweaking as needed.
while($row = mysql_fetch_array($Find_jobs)) {
if ($row[9] != ""){
$col_author = "$Font $FontColorBody $FontSizeSmall by $Font $FontColorBodyLink $FontSizeSmall$row[1]";
} else {
$col_author = "$Font $FontColorBody $FontSizeSmall by $row[1]";
};
if ($row[3] != ""){
$row[3] = "$Font $FontFace $FontColorBody $FontSizeMedium$row[3]";
};
print "
$Font $FontFace $FontColorBody $FontSizeLarge$row[2]
$row[3]
$col_author, $Font $FontFace $FontColorBody $FontSizeSmall $row[5]
$Font $FontFace $FontColorBody $FontSizeMedium$row[6]"; }; print "