[Kindly help] PHP third-level navigation menu does not know how to do it. I don't know which master is helpful. I am in a hurry!
:
Database structure:
--
-- Table structure 'arctype'
--
Create table 'arctype '(
'Id' smallint (5) unsigned not null auto_increment,
'Parid' smallint (5) unsigned not null default '0 ',
'Typerank 'smallint (5) unsigned not null default '0 ',
'Typename' char (15) not null,
'Typedir' char (15) default NULL,
'Typetitle' varchar (80) not null,
'Typekeyword' varchar (120) not null,
'Typedescription' varchar (150) not null,
Primary key ('id ')
ENGINE = MyISAM default charset = utf8 AUTO_INCREMENT = 176;
--
-- Export the data 'arctype 'in the table'
--
Insert into 'arctype 'values (144, 0, 0, 'pronunciation ', 'fayin', 'German pronunciation online learn', 'German pronunciation, German pronunciation online learn, german pronunciation getting started, German pronunciation video, German pronunciation audios, 'we offer online learning of German pronunciation, the best website for German Pronunciation Learning ');
Insert into 'arctype 'values (145, 0, 1, 'syntacay', 'yufa ', 'online learning of German grammar', 'German grammar learning, online learning of German syntax, german grammar exercises, German syntax audio, German syntax video ',' we provide online learning of German syntax, the best German grammar learning website ');
Insert into 'asyncype 'values (146, 0, 2, 'audience', NULL, 'German listening best website', 'German listening learning, German listening online learning, german audio, German audio video, 'we provide online learning for German listening, and the best website for German listening ');
Insert into 'arctype 'values (147, 0, 3, 'read', NULL, 'German reading learn', 'German reading, German reading online learning, German reading getting started, german reading video, German reading audio, 'The online learning of German reading, the best learning website for German reading phones ');
Insert into 'arctype 'values (148, 0, 4, 'write', NULL, 'German writing online learn', 'German writing, German writing online learnings, German writing getting started, video for German writing, audio for German writing, 'The online learning for German writing and the best website for German pronunciation learn ');
Insert into 'arctype 'values (149, 0, 5, 'Word', NULL, 'German words online learn', 'German words, German words online learn', German words getting started, video of German words, audio of German words, 'we offer online learning of German words, the best website for learning German words ');
Insert into 'arctype 'values (163,144, 0, 'consonants ', 'fuin', 'German consonants online learn', 'German consonants, German consonants online learn', German consonants get started, video of German consonants and audio of German consonants, 'the best website for online learning of German consonants and learning of German consonants ');
Insert into 'arctype 'values (164,145, 0, 'GE', 'GE', 'German, online learning, getting started with German, usage Video of German lattice, usage audio of German lattice, usage of German lattice, online learning of usage of German lattice, Introduction to usage of German lattice, usage video of German lattice, the usage audios for German cells, 'The online learning for usage of German cells, the best learning website for usage of German cells ');
Insert into 'arctype 'values (165,164, 0, 'grid ', 'yige', usage of 'German grid -- one grid online learn', one grid for German, and one grid for German online learning, getting started with a German grid, a German grid video, and a German grid audio ',' we provide online learning of a German grid syntax, and the best website for learning a German grid syntax ');
Insert into 'arctype 'values (166,164, 0, '2', 'erge', 'Usage of German lattice-L2 online learn', 'German 2, german second-level online learning, German second-level getting started, German second-level video, German second-level audio ', 'We provide online learning of German second-level syntax, the best website for learning German second-lattice syntax ');
Insert into 'arctype 'values (167,164, 0, 'Three GE', 'sange', 'Usage of German Gex-online learning of three Gex ', 'Three German Gex, three German Gex online learning, getting started with the German three-cell, German three-cell video, German three-cell audio, 'The online learning of German three-cell syntax, the best website for learning German three-cell syntax ');
Insert into 'arctype 'values (168,164, 0, '4ge', 'sige', 'Usage of German lattice -- 4ge online learn', 'German 4ge, German 4ge online learner, getting started with a four-cell German, a video with four-cell German, 'Learn German four-cell syntax online, and the best website for learning German four-cell syntax ');
Reply to discussion (solution)
Nobody help me?
Give a simple test example
If (isset ($ _ GET ['id']) {header ('content-type: text/html; charset = utf-8 '); mysql_connect (); mysql_select_db ('test'); mysql_query ('set names utf8'); $ id = isset ($ _ GET ['id'])? $ _ GET ['id']: 0; $ rs = mysql_query ("select * from arctype where parid = '$ ID '"); while ($ row = mysql_fetch_assoc ($ rs) {echo "$ row [typename]
";}Exit ;}?>
