include("../adodb5/adodb.inc.php"); include("../includes/dbconnect.php"); function getAssetData(){ $conn = dbConnect(); //$conn->deubg=true; $recordSet = &$conn->Execute('select AID, title, file, altfile, largeIMG, thumbnail, displayorder from assets where AID in (select AID from asset_lookup where ATID = 6) and archive =0 order by displayorder ASC'); if (!$recordSet) print $conn->ErrorMsg(); else //while (!$recordSet->EOF) { $assetDetails = $recordSet->GetArray(); //$recordSet->MoveNext(); //$recordSet->Close(); # optional $conn->Close(); # optional return $assetDetails; } $assets = getAssetData(); if($_GET['aid'] != ""){ for($i=0;sizeof($assets);$i++){ if($assets[$i][0] == $_GET['aid']){ $detailImage = $assets[$i][4]; $movieFile = $assets[$i][2]; $ogvFile = $assets[$i][3]; $movieCaption = $assets[$i][1]; break; } } }else{ $detailImage = $assets[0][4]; $movieFile = $assets[0][2]; $ogvFile = $assets[0][3]; $movieCaption = $assets[0][1]; } ?>