mySQL Results To XML
| From: | CK | Date: | Sat, 06 Oct 2007 20:12:29 +0000 |
| Subject: | mySQL Results To XML | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-262877@lists.php.net to get a copy of this message | ||
Hi,
Here's the mission, creating a movie DB, I need the results returned from mySQL in an XML format for use with the FLASH Professional DataGrid. Any tips on formating mySQL results would be grand. Here's the structure of the DB, if needed.
DVD Table
*Title ID
*Title
*Genre
*Actor
*Director
*Producer
*Date Purchased
*Price
*Date Released
*Length
*Plot
*Review(*****)
*Rating
person table
*Producer ID
*First Name
*Last Name
*Director ID
*First Name
*Last Name
Actors_Link
actor_link_id just a primary auto-increment number
person_id
movie_id
role_id