[MusikMixen]

Koden i sin helhet.

   // Connect to the database   
   $link = mysql_connect('localhost',$username,$password);
  mysql_set_charset('utf8',$link);

   // Handle an error
   @mysql_select_db($database) or die( "Unable to select database");



      // Build Sql that returns the data needed - change this as required.   
      $sql = "SELECT songlist.*, historylist.listeners as listeners, historylist.requestID as requestID, historylist.date_played as starttime, songlist.picture as picture FROM historylist,songlist WHERE (historylist.songID = songlist.ID) AND (songlist.songtype='S') ORDER BY historylist.date_played DESC LIMIT 1"; 

      // Store results in result object
      $result = mysql_query($sql);
      
       //store values in vars for calculation for array creation
      $dt_played = mysql_result($result,$i,'date_played');
      $dt_duration = mysql_result($result,$i,'duration');
      $title= mysql_result($result,$i,'title');
      $artist= mysql_result($result,$i,'artist');
      $name= mysql_result($result,$i,'name');
      $msg= mysql_result($result,$i,'msg');
      $picture= rawurlencode(mysql_result($result,$i,'picture'));
       $starttime = strtotime($dt_played);
      $curtime = time();
      $timeleft = $starttime+round($dt_duration/1000)-$curtime;
       $secsRemain = (round($dt_duration / 1000)-($curtime-$starttime));

       
       //build array to return via getXMLHTTPRequest object - you can include more vars but remeber to handle them
       //correcty in the useHttpResponse function       
       $Aj_array = $dt_duration . '|' . $secsRemain . '|' . $title . '|' . $artist .'|' . $name . '|' . $msg .'|' . $picture;

       
       //we are using the text response object  - which i think is easier for small data return
       //just echo the array                 - not so much AJAX rather AJA ??
       echo $Aj_array

?>