Results are die('Error, No Album Search failed'); How do I get the Id
Please hlep:
Code: Select all
if(isset($_GET['userid']))
{
$db =& JFactory::getDBO();
$user =& JFactory::getUser();
$id = $user->id;
$album_id = $_GET['userid'];
$query = 'SELECT user_id, id, format_id, year, name FROM #__muscol_albums WHERE user_id = ' . $album_id;
//$query = 'SELECT user_id FROM #__muscol_albums WHERE id = ' . $album_id ;
$result = mysql_query($query) or die('Error, No Album Search failed');
list($name, $user_id, $id, $year) = mysql_fetch_array($result);
echo $id;
//exit;
}