You are here: I need some help here « PHP SQL « IT news, forums, messages
I need some help here

Posted by sahm on 11/24/06 17:44

Hi evry one
I need some help with my code
What's wrong in this code

<?php


header('Content-Type: text/xml');
$dom = new DOMDocument();
$response = $dom->createElement('response');
$dom->appendChild($response);


$sub_categorys = $dom->createElement('sub_Categorys');
$response->appendChild($sub_categorys);


$conn = mysql_connect("localhost", "", "");
if (!$conn)
{
echo "Unable to connect to DB: " . mysql_error();
exit;


}


else
{
$select = mysql_select_db("yayemen", $conn);
if (!$select)
{
echo "Unable to select mydbname: " . mysql_error();
exit;
}
else
{
$sql = "SELECT * FROM sub_category";
$result = mysql_query($sql, $conn);
}


}


while ($row = mysql_fetch_assoc($result))
{

$cat_NO = $dom->createElement('cat_NO');
$st1 = $row["sub_cat_ID"];
$cat_NO_Text = $dom->createTextNode($st1);
$cat_NO->appendChild($cat_NO_Text);


$cat_Name = $dom->createElement('cat_Name');
$st2 = $row["sub_cat_Name"];
$cat_Name_Text = $dom->createTextNode($st2);
$cat_Name->appendChild($cat_Name_Text);


$sub_category = $dom->createElement('sub_category');
$sub_category->appendChild($cat_NO);
$sub_category->appendChild($cat_Name);


$sub_categorys->appendChild($sub_category);


$xmlString .= $dom->saveXML();



}


echo $xmlString;

?>


please help please

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация