Functions not returning any values

[Harleycoder]

I have a series of functions that pull info out of a db and get values. I can't get them to return ANYTHING. I've been all over the internet searching for an answer and am banging my head on my desk.

Here's what my call looks like:

$prodline=lookupProdLine($clientID);
global $clientID;

I have 3 more functions after that which depend on each others' values returned. I hoep someone can help me! 😕

And the function:
function lookupProdLine($clientID)
{
if ($lookup=mysql_query("SELECT
ProdLine
from CliProd
WHERE ClientID='$clientID'"))
{
while ($row=mysql_fetch_array($lookup))
{
$prodline=$row[0];
global $prodline;
return($prodline);
}

	}
	else
	{
		$goof=mysql_error();
		$error .= "<b>Error:</b>  $goof in lookupProdLine function";
	}

}

[dagon]

if you dont return $error, in the function you will never see it

function lookupProdLine($clientID){
	if($lookup= mysql_query("SELECT ProdLine from CliProd WHERE ClientID='$clientID'")){
		while($row= mysql_fetch_array($lookup)){
			$prodline= $row[0];
			global $prodline;
			return ($prodline);
		}

}else{
	$goof= mysql_error();
	$error= "<b>Error:</b> $goof in lookupProdLine function";
return ($error);
}
}

[Bonesnap]

It appears you're only returning a single value, correct? I am curious why you have a while loop if that's the case. I would write something like:

function lookupProdLine($clientID)
{
    if($lookup = mysql_fetch_row(mysql_query("SELECT ProdLine from CliProd WHERE ClientID='$clientID'")))
         return $lookup[0];
    else
         return mysql_error();
}