I have created a database called friends with four columns:
Name / Address / City / State
I also made an XML file to coincide with those variables:
<test>
<contacts>
<friends>
<name>Friend 1</name>
<address>999 Foo Avenue</address>
<city>Foo Town</city>
<state>FO</state>
</friends>
</contacts>
</test>
The variables in the XML doc above are already in the database
BUT - what I want to do - using PHP and MySQL - is something like this:
$connection = mysql_connect("localhost", "foo", "bar") or die ("Could not
connect to server.");
$db = mysql_select_db("friends") or die ("Could not select database.");
$sql = "select * from friends order by name asc";
$sql_result = mysql_query($sql, $connection) or die ("Could not execute
query.");
echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n";
echo "<?xml-stylesheet type=\"text/xsl\" href=\"friends.xsl\"?>\n\n";
echo "<test>\n";
echo "\t<contacts>\n";
echo "\t\t<friends>\n";
echo "\t\t\t<name>";
echo "$name";
echo "\t\t\t</name>\n";
echo "\t\t\t<address>";
echo "$address";
echo "\t\t\t</address>\n";
echo "\t\t\t<city>";
echo "$city";
echo "\t\t\t</city>\n"
echo "\t\t\t<state>";
echo "$home";
echo "\t\t\t</state>\n";
echo "\t\t</friends>";
echo "\t</contacts>";
echo "</test>";
?>
Can this be done and am I going about it the right way?
Should you have any questions, comments or concerns, feel free to call me
at 318-338-2034.
Thank you for your time,
Jay Fitzgerald, Design Director - CSBW-A, CPW-A, CWD-A, CEMS-A
==========================================================
Bayou Internet..............(888)
30-BAYOU........................http://www.bayou.com
Mississippi Internet.......(800)
MISSISSIPPI...............http://www.mississippi.net
Vicksburg Online..........(800)
MISSISSIPPI................http://www.vicksburg.com
==========================================================
Tel: (318) 338-2034 ICQ: 38823829 Fax:
(318) 323-5053
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
