write a xml script

NZ_Kiwis

I want to do a mysql qurey and write the results into a xml page
does anyone have a code to start this off?

Weedpacket

It's no different to doing a MySQL query and writing the results into an HTML page.

NZ_Kiwis

and how is this done?

Weedpacket

You mean you've never taken results from a MySQL query and put them in an HTML page?

leatherback

if you don't know..
(I never realized how often I could use my tutorials...):

http://www.bio-vision.nl/coding/select_from.php

thepeccavi

Firstly do everything to MySQL...

// Connect to MySQL
$mysqlConnection = mysql_connect(<HOSTNAME>, <USERNAME>, <PASSWORD>);

// Select the database:
mysql_select_db(<DATABASE NAME>);

// Create your query
$query = "<SQL QUERY CODE>";

// Run that query
$results = mysql_query($query);

Now we process that information:

while($row = mysql_fetch_assoc($results)){
printf("<HTML CODE INCLUDING "%s" WHEN EVER YOU WANT A FIELD FROM THE DB>", $row["<NAME OF FIELD FOR FIRST INSTANCE OF %s>"], $row["<NAME OF FIELD FOR FIRST INSTANCE OF %s>", etc......);
}

Hope that helps.

NZ_Kiwis

Weedpacket wrote:
You mean you've never taken results from a MySQL query and put them in an HTML page?

But i want to write my own xml page.