Keskustelu: Nettisivujen teko: Ongelma taulun tietojen tulostuksessa

<?php

function show_all_news($category) {
	global $prefix, $settings, $conf;

	// Kategoria ?
	if (strstr($category,',')) {
		$categor = explode(",",$category);
		$qcate = " AND (";

		foreach ($categor as $key => $poo) {
			if (count($categor) == $key) {
				$qcate .= " category = ".db_escape($poo)."";
			}
			else {
				$qcate .= " category = ".db_escape($poo)." OR";
			}
		}
		$qcate = preg_replace("/OR$/","",$qcate);
		$qcate .= " )";
	}
	elseif ($category != "*") {
		$qcate = " AND category = ".db_escape($category)." ";
	}
	else {
		$qcate = "";
	}


	$q = db_query("SELECT * FROM {$prefix}news WHERE send_time < ".time()." ".$qcate." ORDER BY id");

	while ($new = db_fetch_array($q)) {
		$buffer = '»<a href="' . $settings['url'] . 'index.php?s=' . $_REQUEST['s'] . '&amp;nayta='  . $new['id'] . '">' . htmlspecialchars($new['title']) . '</a><br />';
	}

	return $buffer;
}

?>