|
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]
|