Listing 1545

if(!isset($_GET['key']))
{
$self = $_SERVER['PHP_SELF'];
 
$query = " SELECT id, `key`, title FROM cms3 GROUP BY `key`";
$result = mysql_query($query) or die('Error : ' . mysql_error());
 
// post list
$content = '<ol>';
while($row = mysql_fetch_array($result, MYSQL_NUM))
{
list($id, $key, $title) = $row;
$content .= "<li><a href=\"$key\">$title</a>$key</li>\r\n";
}
 
 
$content .= '</ol>';
 
$title = 'Posts';
 
} else {
 
/// linki za pornstarke
$query = "SELECT * FROM cms1 WHERE `key` LIKE '%".$_GET['key']. "%'";
$result = mysql_query($query) or die('Error : ' . mysql_error());
$row = mysql_fetch_array($result, MYSQL_ASSOC);
 
$pornstars = '<ol>';
while($row = mysql_fetch_array($result, MYSQL_NUM))
{
list($id, $key, $linktitle, $linkdesc) = $row;
$pornstars .= "<li><a href=\"$linktitle\">$linkdesc</a>$key</li>\r\n";
}
 
 
$pornstars .= '</ol>';
 
$title = 'Posts';
 
}