Htio bih napraviti nesto za pocetnu stzranicu, a to je da mi prikazuje neku slucajnu (random sliku) iz baze.
Evo strukture tabele gdje su smjestene slike
CREATE TABLE `4images_images` (
`image_id` int(10) unsigned NOT NULL auto_increment,
`cat_id` int(10) unsigned NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`image_name` varchar(255) NOT NULL default '',
`image_description` text NOT NULL,
`image_keywords` text NOT NULL,
`image_date` int(11) unsigned NOT NULL default '0',
`image_active` tinyint(1) NOT NULL default '1',
`image_media_file` varchar(255) NOT NULL default '',
`image_thumb_file` varchar(255) NOT NULL default '',
`image_download_url` varchar(255) NOT NULL default '',
`image_allow_comments` tinyint(1) NOT NULL default '1',
`image_comments` int(10) unsigned NOT NULL default '0',
`image_downloads` int(10) unsigned NOT NULL default '0',
`image_votes` int(10) unsigned NOT NULL default '0',
`image_rating` decimal(4,2) NOT NULL default '0.00',
`image_hits` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`image_id`),
KEY `cat_id` (`cat_id`),
KEY `user_id` (`user_id`),
KEY `image_date` (`image_date`),
KEY `image_active` (`image_active`)
) ENGINE=MyISAM AUTO_INCREMENT=938 ;
Pa ako ko moze pomoci, ako ima kakav PHP kod dobro bi doslo.
Unaprijed hvala