hi there hello list
first of all - this is slightly off - topic. but i need your helphere i want to do some db-requests via a phpMyadmin frontend. please advice - i am aware that this is slightly of topic but - i needhelp with a SELECT-STATEMENT here we go; the dump looks like this: [PHP]-- Tabellenstruktur für Tabelle `vrienden` -- DROP TABLE IF EXISTS `vrienden`; CREATE TABLE IF NOT EXISTS `vrienden` ( `contactID` smallint(6) NOT NULL AUTO_INCREMENT, `E-Mail Adresse` tinytext, `Institut-Name` text NOT NULL, `E-Mail Adresse 2` tinytext, `E-Mail Adresse 3` tinytext, `weitere E-Mail-Adressen` varchar(255) DEFAULT NULL, `Vorname` varchar(255) DEFAULT NULL, `Name` varchar(255) DEFAULT NULL, `Schwerpunkt` text NOT NULL, `Besonderes` text NOT NULL, `Webseite` varchar(255) DEFAULT NULL, `kontakt` tinyint(1) NOT NULL, PRIMARY KEY (`contactID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12233 ; -- -- Daten für Tabelle `vrienden` -- INSERT INTO `vrienden` (`contactID`, `E-Mail Adresse`, `Institut-Name`, `E-Mail Adresse 2`, `E-Mail Adresse 3`, `weitere E-Mail-Adressen`, `Vorname`, `Name`, `Schwerpunkt`, `Besonderes`, `Webseite`, `kontakt`) VALUES (1, '0', '0', '0', '0', '', NULL, NULL, '', '', NULL, 0), (2, '0', '0', '0', '0', '', NULL, NULL, '', '', NULL, 0), (3, '0', '0', '0', '0', '', NULL, NULL, '', '', NULL, 0), (4, '', '0', '0', '0', '', NULL, NULL, '', '', NULL, 0), (5, '0', '0', '0', '0', '', NULL, NULL, '', '', NULL, 0), [/PHP]and so on... there is a huge dataset with more than 800 lines How to ask the db - with the SELECT-STATEMENT... Goal: i want to give out the following datas: [PHP] `contactID` smallint(6) NOT NULL AUTO_INCREMENT, `E-Mail Adresse` tinytext, `Institut-Name` text NOT NULL,[/PHP] where the CID has the following values 45,54,56,70,71,91,92,93,94,96,97,98,100,102,103 and so on.,. how to enter - and - (that seems the point -- how to separate the values in the request. Note i use the phpMyadmin-frontedend. can you give me a hint.... many thanks in advance... look forward to hear from you.. best regards. yours jobstler PS - if you need more input then let me know.. _____________________________________________________________________ Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! http://smartsurfer.web.de/?mc=100071&distributionid=000000000066 -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/
