error in query

[autocolismo]

Why does this code doesn't func????
The error comes when i make the second query "$detalhenoticia".

<?php
require_once('../Connections/noticias.php');
mysql_select_db($database_noticias, $noticias);
$query_titulos = "SELECT noticias.titulo, noticias.id FROM noticias";
$titulos = mysql_query($query_titulos, $noticias) or die(mysql_error());
$row_titulos = mysql_fetch_assoc($titulos);
$totalRows_titulos = mysql_num_rows($titulos);

function listar() {	
	$id = $HTTP_GET_VARS['idn'];
	$query_detalhenoticia = "SELECT * FROM noticias WHERE id = '$id'";
	$detalhenoticia = mysql_query($query_detalhenoticia, $noticias) or die(mysql_error());
	$row_detalhenoticia = mysql_fetch_assoc($detalhenoticia);
	$totalRows_detalhenoticia = mysql_num_rows($detalhenoticia); 
	$data = $row_detalhenoticia['data'];
	$resumo = $row_detalhenoticia['resumo'];
	$titulo = $row_detalhenoticia['titulo'];
	$noticia = $row_detalhenoticia['noticia'];
	echo $data . " " . $resumo . " " . $titulo . " " . $noticia;
}
if (isset ($HTTP_GET_VARS['idn'])){
listar();
}else{

do { 
   $link = "idn=".$row_titulos['id']."&action=".$HTTP_GET_VARS['action'];
   echo "<a href=?" . $link . ">" . $row_titulos['titulo'] . "</a><br>";
} while
   ($row_titulos = mysql_fetch_assoc($titulos)); }
?>

[volleytotal_ch]

the function doesn't know your database!
This is because of how function works: they just know the variables you submit to the function and the variables you defined as global.

If you want to use the database within the function, use global to get information about the database - quite difficult to explain but i give you the example so that you should be able to imagine what i mean 😉

function listar() {
    // this makes the variables global so that the function can use them!
    global $HTTP_GET_VARS, $noticias;
    $id = $HTTP_GET_VARS['idn'];
    $query_detalhenoticia = "SELECT * FROM noticias WHERE id = '$id'";
    $detalhenoticia = mysql_query($query_detalhenoticia, $noticias) or die(mysql_error());
    $row_detalhenoticia = mysql_fetch_assoc($detalhenoticia);
    $totalRows_detalhenoticia = mysql_num_rows($detalhenoticia); 
    $data = $row_detalhenoticia['data'];
    $resumo = $row_detalhenoticia['resumo'];
    $titulo = $row_detalhenoticia['titulo'];
    $noticia = $row_detalhenoticia['noticia'];
    echo $data . " " . $resumo . " " . $titulo . " " . $noticia;
}

by the way:
Why do you use a function?
Just do it as an if-command:

....
if (isset ($HTTP_GET_VARS['idn']))
{
    $id = $HTTP_GET_VARS['idn'];
    $query_detalhenoticia = "SELECT * FROM noticias WHERE id = '$id'";
    $detalhenoticia = mysql_query($query_detalhenoticia, $noticias) or die(mysql_error());
    $row_detalhenoticia = mysql_fetch_assoc($detalhenoticia);
    $totalRows_detalhenoticia = mysql_num_rows($detalhenoticia); 
    $data = $row_detalhenoticia['data'];
    $resumo = $row_detalhenoticia['resumo'];
    $titulo = $row_detalhenoticia['titulo'];
    $noticia = $row_detalhenoticia['noticia'];
    echo $data . " " . $resumo . " " . $titulo . " " . $noticia;
}
else
{
....

hope that helps 😉

[autocolismo]

Thanks dude

I am experiencing some codes and its easier and simpler to control it all if i make it with functions. i'm new in programming and when i start it all becames a fukin CAOS, if you know what i mean.

😃