[[PAUL FERRIE]]

Hi guys,

Well i decided to by a new book: FOED Object Oriented Actionscript 3
So far good read :>

Ok my problem

I am trying to connect to one of my exsisiting database's and display the data in flex.

I ran my php script and it returns the relevant data

PHP Code:

<?PHP

include('../forum/common.php');

$link = dbConnect();

$query = "SELECT * FROM idblogg ORDER BY newsDate DESC";

$result = mysql_query($query);     

if (!$result) {

    fail("Couldn't list news stories from database");

}

$newsCount = mysql_num_rows($result);

$Return = "<newsArchive>";

for ($count = 0; $count < $newsCount; $count++){

    $news         = mysql_fetch_array($result);

    $newsID     = $news['newsID'];

    $newsTitle     = $news['newsTitle'];

    $newsStory     = $news['newsStory'];

    $newsDate     = date("j-m-y", strtotime($news['newsDate']));

    $newsHits    = $news['newsHits'];

    //

    $allComms = dbQueryFirst("SELECT COUNT(*) AS totalComm FROM idbloggcomm  WHERE blogg_id = $newsID");



    if (!$allComms) {

           $newsComms = 0;

    } else {

        $newsComms  = $allComms['totalComm'];

    }    

//------------------------------------------------------//    

    $Return .= "<news>

                    <newsID>".$newsID."</newsID>

                    <newsTitle>".$newsTitle."</newsTitle>

                    <newsStory>".$newsStory."</newsStory>

                    <newsDate>".$newsDate."</newsDate>

                    <newsComms>".$newsComms."</newsComms>

                    <newsHits>".$newsHits."</newsHits>

                </news>";    

}

$Return .= "</newsArchive>";

mysql_free_result( $result );

print ($Return);

?>

When i run flex i get this error

[RPC Fault faultString="Error #1096: XML parser failure: Unterminated element." faultCode="Client.CouldNotDecode" faultDetail="null"]

	at mx.rpc.http::HTTPService/http://www.adobe.com/2006/flex/mx/internal::processResult()

	at mx.rpc::AbstractInvoker/http://www.adobe.com/2006/flex/mx/internal::resultHandler()

	at mx.rpc::Responder/result()

	at mx.rpc::AsyncRequest/acknowledge()

	at ::DirectHTTPMessageResponder/completeHandler()

	at flash.events::EventDispatcher/flash.events:EventDispatcher::dispatchEventFunctio  n()

	at flash.events::EventDispatcher/dispatchEvent()

	at flash.net::URLLoader/flash.net:URLLoader::onComplete()

"XML parser failure: Unterminated element"

Flex code:

Code:

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" xmlns="*" layout="absolute" creationComplete="newsRequest.send()">
   <mx:HTTPService id="newsRequest" url="http://www.domain.com/flex_news_archive.php" useProxy="false" method="POST">
      <mx:request xmlns="">
      </mx:request>
   </mx:HTTPService>
   <mx:TitleWindow x="0" y="0" width="891" height="210" layout="absolute" borderColor="#808080" title="Innovative designs news archive" borderStyle="inset">
      <mx:DataGrid id="dgNewsRequest" x="0" y="1" dataProvider="{newsRequest.lastResult.newsArchive.news}" width="857" height="160">
         <mx:columns>
            <mx:DataGridColumn headerText="news ID" dataField="newsID"/>
            <mx:DataGridColumn headerText="Title" dataField="newsTitle"/>
            <mx:DataGridColumn headerText="Description" dataField="newsDesc"/>
            <mx:DataGridColumn headerText="Submitted" dataField="newsDate"/>
            <mx:DataGridColumn headerText="Comments" dataField="newsComms"/>
            <mx:DataGridColumn headerText="Views" dataField="newsHits"/>
         </mx:columns>
      </mx:DataGrid>
   </mx:TitleWindow>
</mx:Application>

I presume this means that one of the tags is not closed properly?


Thanks
Paul