hi there
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:
[code=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=InnoDB 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),
[/code]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:
`contactID` smallint(6) NOT NULL AUTO_INCREMENT,
`E-Mail Adresse` tinytext,
`Institut-Name` text NOT NULL,
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.
meta
PS - if you need more input then let me know..
