Sandbox

Code: Select all

<?php

defined( '_VALID_MOS' ) or
    die( 'Direct Access to this location is not allowed.' );

$conn = mysql_connect(localhost,JoeBlogs,secret) ;

mysql_select_db(external_database) ; 

$result = mysql_query("SELECT artist, title from historylist ORDER BY historylist.date_played DESC");

list($title,$artist)= mysql_fetch_row($result);
 	 
	 echo $title ;   echo "<br>" ;
	  echo $artist ; echo "<br>" ;
		 
 ?>

Code: Select all

<?php

defined( '_VALID_MOS' ) or
    die( 'Direct Access to this location is not allowed.' );
	
$option['driver']   = 'mysql';            // Database driver name
$option['host']     = 'localhost';    // Database host name
$option['user']     = 'joebloggs';       // User for database authentication
$option['password'] = 'secret';  // Password for database authentication
$option['database'] = 'external database';      // Database name
$option['prefix']   = '';             // Database prefix (may be empty)

$database = & JDatabase::getInstance( $option );


$sql= "SELECT artist, title from historylist ORDER BY date_played DESC" ;

$database->setQuery( $sql );

$category = $database->loadRow();

 
echo $category ;
	
		  echo "<br>" ;
		  
 ?>