Keskustelu: Nettisivujen teko: Miksi ei toimi

<?php
if(!$dbconnect = mysql_connect('localhost', 'root', '')) {
   echo "Connection failed to the host 'localhost'.";
   exit;
} // if
if (!mysql_select_db('tuotteet')) {
   echo "Cannot connect to database 'tuotteet'";
   exit;
} // if

$table_id = 'auto1';
$table_id1 = 'auto2';

$query = "SELECT merkki FROM $table_id";
$query1 = "SELECT malli FROM $table_id1";


$dbresult = mysql_query($query, $dbconnect);
$dbresult1 = mysql_query($query1, $dbconnect);
// create a new XML document
$doc = new DomDocument('1.0');

// create root node
$root = $doc->createElement('menu');
$root = $doc->appendChild($root);

// process one row at a time
while($row = mysql_fetch_assoc($dbresult)) {

  // add node for each row
  $occ = $doc->createElement('item');
  $occ = $root->appendChild($occ);


while($row1 = mysql_fetch_assoc($dbresult1)) {

  $occ1 = $doc->createElement('item');
  $occ1 = $occ->appendChild($occ1);

}


  foreach ($row as $fieldname => $fieldvalue) {

	$occ->setAttribute('caption', $fieldvalue);
	$occ1->setAttribute('caption', $fieldvalue);

     } // foreach
 } // while


 $doc->save('testing.xml');


?>

-
	<menu>
-
	<item caption="Mercedes-benz">
<item/>
<item/>
<item/>
<item/>
<item/>
<item/>
<item/>
<item/>
<item/>
<item caption="Mitsubishi"/>
</item>
<item caption="Mazda"/>
<item caption="Mitsubishi"/>
</menu>