How to populate listview with remote xml data?

[tony007]

Mark i realy thank you for this usefull code. It is working.However,

is there a way to create another listview and populate it with initial data and each time compare the Name columns of both listviews and if they are diffrent update the second listview. I am thinking of some how hiding unessary refreshes since i keep loosing focouse on the form!!could you help me with a solution for this unncessary refreshes?


Furthermore, In the same project i added another timer that frequently checks a remote xml. What i want this new timer some how check if the rss feed is giving any result/data set out. If it gives data out i need for example reload webbrowser controle.If it doesn't give any data out i do nothing. (I don't need to output xml content)Could you show me how i can make such check using your code.Thanks

Note:The url to check for its xml data is like this:
'http://localhost//datastatus.php?sessionkey=b429632c627bcf6bd4840561690e3c49

Private Sub Form_Load()
    'Set up the listview
    ListView1.View = lvwReport
    ListView1.ColumnHeaders.Add , , "Artist"
    ListView1.ColumnHeaders.Add , , "Name"
    ListView1.ColumnHeaders.Add , , "Image"
    ListView1.ColumnHeaders.Add , , "Rating"
    ListView1.ColumnHeaders.Add , , "Song ID"
    ListView1.ColumnHeaders.Add , , "Total Votes"
    PopulateListview
    
    'Timer1.Interval = 60000 ' <-- one minute
    Timer1.Interval = 7000 ' <-- 10 seconds
    Timer1.Enabled = True
    
     Timer2.Interval = 7000 ' <-- 10 seconds
    Timer2.Enabled = True
End Sub
 
Private Sub Timer2_Timer()
Static lngMin As Long
 
    lngMin = lngMin + 1
    
    'every 2nd timer tick reload the listview
    If lngMin Mod 2 Then
        checkForNewData
    End If
 
End Sub
 
Private Sub checkForNewData()
'Here i need to check for new data . If new data is avalible then
'reload the webbrowser.
 
'i need some how check if the following php code outputs any xml or not?
'http://localhost//datastatus.php?sessionkey=b429632c627bcf6bd4840561690e3c49
 
 
End Sub

datastatus.php

<?php
header("Cache-Control: no-cache, must-revalidate");
    header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");

$sessionkey=$_GET['sessionkey'];

$server   = "localhost"; // MySQL hostname
$username = "root"; // MySQL username
$password = "root"; // MySQL password
$dbname   = "db"; // MySQL db name

$db = mysql_connect($server, $username, $password) or die(mysql_error());
      mysql_select_db($dbname) or die(mysql_error());

// this is necessary, otherwise it won't work: 
header('Content-type: application/xml'); 
// you need to return the error as xml as well 
$res = mysql_query("SELECT w,h FROM datastatus WHERE who_sessid ='$sessionkey' ") or die('<error>'.mysql_error().'</error>');
// display the root node of the xml, and start looping over the elements: 
echo '<playlist>'; 
while($row = mysql_fetch_assoc($res)){ 
  echo '<song>'; 
  echo '<artist>'.$row['w'].'</artist>'; 
  echo '<name>'.$row['h'].'</name>'; 
  echo '</song>'; 
} 
echo '</playlist>';  


?>