Generate XML Problem

[mcamilleri]

Hi I am trying to modify a php script in order to generate an XML file from a MySQL DB.

 

I am having problems to display the following:

 

The ideal chunk of code should be:

 

<CDWA16_subjectMatterWrapper>
  <CDWA16.1_subjectDisplay /> 
- <subjectIndexingTermsWrapper>
  <CDWA16.2_subjectIndexingTerms>Ceramics</CDWA16.2_subjectIndexingTerms> 
  <CDWA16.2.1_subjectIndexingType /> 
  <CDWA16.2.2_subjectExtent /> 
  </subjectIndexingTermsWrapper>
- <subjectIndexingTermsWrapper>
  <CDWA16.2_subjectIndexingTerms>Prehistoric antiquities</CDWA16.2_subjectIndexingTerms> 
  <CDWA16.2.1_subjectIndexingType /> 
  <CDWA16.2.2_subjectExtent /> 
  </subjectIndexingTermsWrapper>
- <subjectIndexingTermsWrapper>
  <CDWA16.2_subjectIndexingTerms>Decoration and ornament, Prehistoric</CDWA16.2_subjectIndexingTerms> 
  <CDWA16.2.1_subjectIndexingType /> 
  <CDWA16.2.2_subjectExtent /> 
  </subjectIndexingTermsWrapper>
- <subjectIndexingTermsWrapper>
  <CDWA16.2_subjectIndexingTerms>Slipware</CDWA16.2_subjectIndexingTerms> 
  <CDWA16.2.1_subjectIndexingType /> 
  <CDWA16.2.2_subjectExtent /> 
  </subjectIndexingTermsWrapper>
- <subjectIndexingTermsWrapper>
  <CDWA16.2_subjectIndexingTerms>Pottery, Prehistoric</CDWA16.2_subjectIndexingTerms> 
  <CDWA16.2.1_subjectIndexingType /> 
  <CDWA16.2.2_subjectExtent /> 
  </subjectIndexingTermsWrapper>
- <subjectIndexingTermsWrapper>
  <CDWA16.2_subjectIndexingTerms>Ceramic bowl</CDWA16.2_subjectIndexingTerms> 
  <CDWA16.2.1_subjectIndexingType /> 
  <CDWA16.2.2_subjectExtent /> 
  </subjectIndexingTermsWrapper>
  <CDWA16.3_subjectInterpretiveHistory /> 
  <CDWA16.4_remarks /> 
- <citationsWrapper>
  <CDWA16.5_citations /> 
  <CDWA16.5.1_page /> 
  </citationsWrapper>
  </CDWA16_subjectMatterWrapper>

 

My Result is:

 

<CDWA16_subjectMatterWrapper>
  <CDWA16.1_subjectDisplay /> 
- <subjectIndexingTermsWrapper>
  <CDWA16.2_subjectIndexingTerms>Ceramics</CDWA16.2_subjectIndexingTerms> 
  <CDWA16.2_subjectIndexingTerms>Ceramic bowl</CDWA16.2_subjectIndexingTerms> 
  <CDWA16.2_subjectIndexingTerms>Pottery, Prehistoric</CDWA16.2_subjectIndexingTerms> 
  <CDWA16.2_subjectIndexingTerms>Prehistoric antiquities</CDWA16.2_subjectIndexingTerms> 
  <CDWA16.2_subjectIndexingTerms>Slipware</CDWA16.2_subjectIndexingTerms> 
  <CDWA16.2_subjectIndexingTerms>Decoration and ornament, Prehistoric</CDWA16.2_subjectIndexingTerms> 
  <CDWA16.2.1_subjectIndexingType /> 
  <CDWA16.2.2_subjectExtent /> 
  </subjectIndexingTermsWrapper>
  <citationGROUP /> 
  </CDWA16_subjectMatterWrapper>

 

This is my code:

 

echo "<CDWA16_subjectMatterWrapper>";

	if ( $ndot1  == "" ) 
			echo "<CDWA16.1_subjectDisplay/>";
		echo $ndot1 ;



		echo "<subjectIndexingTermsWrapper>";
		if ( $ndot2  == "" ) 
			echo "<CDWA16.2_subjectIndexingTerms/>";
			echo $ndot2 ;


			if ( $ndot2dot1  == "" ) 
			echo "<CDWA16.2.1_subjectIndexingType/>";
			echo $ndot2dot1 ;			
			if ( $ndot2dot2  == "" ) 
			echo "<CDWA16.2.2_subjectExtent/>";
			echo $ndot2dot2 ;		
		echo "</subjectIndexingTermsWrapper>";

[PFMaBiSmAd]

It would probably help if you showed your mysql query and php code that is retrieving the data and how the data is associated to the correct level (your $ndot1, $ndot2,... values.)