This function is corret?

nielson

I am Brazilian and I speak a badly little about English,

but I am with a doubt: I can place values

of return of a function in a control structure as the while

Example:

if($num == 0) {

$link =" <td>Nenhuma category was added </td>"; / / any category not to exist

return $link;

}

else {

$sel = $this->resultado (" SELECT * FROM phpdown_categorias ORDER BY name ASC",1);

while($res = mysql_fetch_object($sel)) {

$cat_id = $res->id;

$cat_nome = $res->nome;

$link =" <td><a href = \ " listar.php?cat=$cat_id \"> $cat_nome </a></td>";

return $link;

}

}

is function it is correct? is not she coming back any value, but all the variables are of local mark I only want her to come back $link but am not I getting, could anybody help me?

rharter

i'm a bit tired but it doesn't look like you executed the query ....

$sel contains the sql, not the result

so
$result = mysql_query($sel);

then check $result

nielson

Yes but, I'm are working with objetcs and my function resultado() is :
function resultado($q,$t) {
$res = mysql_query($q);
switch($t){
case 1:
return $res;
break;
case 2:
$array = mysql_num_rows($res);
return $array;
break;
}
}
This function are corret!
But my problema is this:

Example:
if($num == 0) {
$link =" <td>Nenhuma categoria foi adicionada</td>"; / / any category not to exist
return $link;
}
else {
$sel = $this->resultado (" SELECT * FROM phpdown_categorias ORDER BY name ASC",1);
while($res = mysql_fetch_object($sel)) {
$cat_id = $res->id;
$cat_nome = $res->nome;
$link =" <td><a href = \ " listar.php?cat=$cat_id \"> $cat_nome </a></td>";
return $link;
}
}

is function it is correct? is not she coming back any value, but all the variables are of local mark I only want her to come back $link but am not I getting, could anybody help me?

MrAlaska

If $link is EMPTY it would mean there is something wrong with the way you are calling it. This returns $link, I copied your first conditional statement:

<?php
$link=test(0);
echo $link;

function test($num){
	if($num == 0) {
		$link ="<td>Nenhuma categoria foi adicionada</td>";
		return $link;
	}
}
?>

rharter

try defining resultado like this

function &resultado(....)

and calling it like this

$var =& this->resultado(x,y);

and see ifyou get a better result,
r

nielson

yes,

but it is that I want to know even, the part of the script is been:

return $link; it can be inside of the while

rharter

no, as soon as you execute return the function is exited.

you can make link an array and increment a value so you can copy all the links into the array, and then return the array at the end.