error jump to row 0

[stalk]

hello, I have a problem : What is it?

Warning: Unable to jump to row 0 on MySQL result index 2 in c:\apache\htdocs\cd_shop\funkcie_s_databazou.php on line 899

[silviuks]

can you paste mooore lines of code?

[stalk]

this is code, which display basket of online shop. And I need give to var: $cd details of product which process function vyber_detaily_tovaru($EAN_kod); Thanks for your help

foreach ($kosik as $EAN_kod => $qty) { $cd = vyber_detaily_cd($EAN_kod); $ciste = vyber_detaily_media($EAN_kod); echo ""; if($obrazky ==true) { echo ""; if (file_exists("obrazky/albumy/".$EAN_kod.".gif")) { $size = GetImageSize("obrazky/albumy/".$EAN_kod.".gif"); if($size[0]>0 && $size[1]>0) { echo ""; } } else echo " "; echo ""; } echo ""; echo "".$cd["album"]." by ".$cd["interpret"]; echo "".number_format($cd["cena"], 2)." Sk"; echo "";

//ak povolime zmeny, pocet kusov danej polozky sa bude nachadzat v textboxe
if ($zmena == true)
echo "";
else
echo $qty;
echo "".number_format($cd["cena"]*$qty, 2)." Sk\n";
}

//zobrazenie riadku z celkovou cenou
echo " 
$polozky
".number_format($celkova_cena, 2)." Sk";

//zobrazenie tlacitka ulozit zmeny
if($zmena == true)
{
echo " 


 
";
}
echo "";
}

this is code of function: vyber_detaily_tovaru($EAN_kod);

function vyber_detaily_tovaru($EAN_kod)
//funkcia ziskavajuca z databazy detaily konkretneho tovaru podla EAN kodu
{
//poziadavka pre databazu o konkretne detaily tovaru
if (!$EAN_kod || $EAN_kod=="")
return false;

$conn = db_connect();

$query="select * from albumy left join ciste_media on albumy.EAN_kod=ciste_media.EAN_kod where albumy.EAN_kod='$EAN_kod' and ciste_media.EAN_kod='$EAN_kod'";

// $query = "select * from ciste_media where EAN_kod='$EAN_kod'";
$result = @mysql_query($query);
if (!$result)
return false;
$result = @mysql_fetch_array($result);
return $result;
}

[stalk]

Is it possible to make this operation? $musica = vyber_detaily_cd($EAN_kod);
$ciste = vyber_detaily_media($EAN_kod);
$cd=$musica.$ciste;

How I join this variable? $ musica and $ ciste to one variable: $cd ? function vyber_detaily_cd and vyber_detaily_media($EAN_kod) select details of product which is in database and I need display this detail in shop basket when is used only one variable $cd. So I must join it to one variable $cd.