|
Pozdrav svima.
Treba mi objasnjenje kako da uradim skriptu (upit) kojom bih mogao da izlistam sve komentare jednog korisnika.
Evo MySQL tabela "komentari" i "korisnik":
-- --------------------------------------------------------
--
-- Table structure for table `komentari`
--
CREATE TABLE IF NOT EXISTS `komentari` (
`id` int(70) NOT NULL AUTO_INCREMENT,
`ime` varchar(20) COLLATE utf8_slovenian_ci NOT NULL,
`text` text COLLATE utf8_slovenian_ci NOT NULL,
`igrice_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `igrice_id` (`igrice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci AUTO_INCREMENT=2 ;
--
-- Dumping data for table `komentari`
--
INSERT INTO `komentari` (`id`, `ime`, `text`, `igrice_id`) VALUES
(1, 'neki komentar', 'Ovo su detalji komentara', 1);
-- --------------------------------------------------------
--
-- Table structure for table `korisnik`
--
CREATE TABLE IF NOT EXISTS `korisnik` (
`user` varchar(20) COLLATE utf8_slovenian_ci NOT NULL,
`pass` varchar(255) COLLATE utf8_slovenian_ci NOT NULL,
`ime` varchar(20) COLLATE utf8_slovenian_ci NOT NULL,
`prezime` varchar(20) COLLATE utf8_slovenian_ci NOT NULL,
`drzava` varchar(20) COLLATE utf8_slovenian_ci DEFAULT NULL,
`grad` varchar(20) COLLATE utf8_slovenian_ci DEFAULT NULL,
`adresa` varchar(30) COLLATE utf8_slovenian_ci DEFAULT NULL,
`telefon` varchar(11) COLLATE utf8_slovenian_ci DEFAULT NULL,
`mail` varchar(20) COLLATE utf8_slovenian_ci DEFAULT NULL,
PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;
--
-- Dumping data for table `korisnik`
--
INSERT INTO `korisnik` (`user`, `pass`, `ime`, `prezime`, `drzava`, `grad`, `adresa`, `telefon`, `mail`) VALUES
-- --------------------------------------------------------
Nadam se da sam bio jasan.
Hvala unaprijed.
|
