include ( '../gtiUtils.php' ); $conn = mysql_connect( SERVIDOR_BD, USUARIO_BD, PASS_BD ); mysql_select_db("gti",$conn); //$ssql = "SET OPTION SQL_BIG_TABLES = 1"; $idTesis = $_GET["id"]; $ssql = "SELECT * FROM tesisDoctoral td WHERE td.idTesis =".$idTesis; $rs = mysql_query($ssql,$conn) or die (mysql_error()); if (mysql_num_rows($rs) == 0) echo 'This paper no longer has a bibtex reference'; else { $row = mysql_fetch_assoc ($rs); $stEntry = '@phdthesis'; $title = 'title = "'.$row['titulo'].'"'; $tituloK = $row['titulo']; $year = 'year = "'.$row['anho'].'"'; $anhoK = $row['anho']; $ssql = 'SELECT * from autoresGti WHERE idAutor ='.$row['idAutor']; mysql_free_result ($rs); $rs = mysql_query($ssql,$conn) or die (mysql_error()); $nAutores = mysql_num_rows($rs); $authors = 'author = "'; if ($row = mysql_fetch_assoc ($rs)) { $authors.=$row['nick']; $autoresK = $row['apellidos']; } $authors.='"'; $arrayA = explode (" ",$autoresK); $key = $arrayA[0]; $key.= substr($anhoK,2,2); $school = 'school = "Departament de Sistemes Informàtics i Computació, Universitat Politècnica de València"'; echo "
".$stEntry."{".$key.","; } ?>
"." ".$authors.",
"." ".$title.",
"; echo " ".$school.",
"." ".$year."
"."}