
Baza :
Kod
CREATE TABLE IF NOT EXISTS `shity` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(60) NOT NULL,
`img` text NOT NULL,
`source` text,
`author` text NOT NULL,
`data` text NOT NULL,
`is_waiting` int(11) NOT NULL DEFAULT '1',
`type` varchar(30) NOT NULL DEFAULT 'obrazek',
`share` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=30;
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(60) NOT NULL,
`img` text NOT NULL,
`source` text,
`author` text NOT NULL,
`data` text NOT NULL,
`is_waiting` int(11) NOT NULL DEFAULT '1',
`type` varchar(30) NOT NULL DEFAULT 'obrazek',
`share` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=30;
Kod w portal.php
Kod
$imgenginer = '';
$query = $db->query("
SELECT img, data, type, title, id
FROM shity
ORDER BY data DESC LIMIT 10");
$img_name = 'obrazek';
$flash_name = 'film';
if(mysql_num_rows($query)) {
while($img = mysql_fetch_array($query)) {
if($img['type'] == $img_name) {
echo '
<a href="obrazek.php?'.$img['id'].'"><img src="'.$img['img'].'" alt="'.$img['title'].'" /></a>
';
}
else if($img['type'] == $flash_name) {
echo 'na razie nie potrzebne';
}
}
}
$query = $db->query("
SELECT img, data, type, title, id
FROM shity
ORDER BY data DESC LIMIT 10");
$img_name = 'obrazek';
$flash_name = 'film';
if(mysql_num_rows($query)) {
while($img = mysql_fetch_array($query)) {
if($img['type'] == $img_name) {
echo '
<a href="obrazek.php?'.$img['id'].'"><img src="'.$img['img'].'" alt="'.$img['title'].'" /></a>
';
}
else if($img['type'] == $flash_name) {
echo 'na razie nie potrzebne';
}
}
}