Function trouble

kycan

Here is what I have.

function titlestring($case)
{
$query = mysql_query ("SELECT title FROM content WHERE simplename LIKE '$case'");
$row = mysql_fetch_row($query);
$title = $row[0];

return $title;
}

Problem is, when I try to get the value of $title later, it draws a blank (yes, the query does return just ONE value).

I know it is something very basic I'm missing here, but what?

pnoeric

Chris - the value $title is only local to the function; the "return" command in this case passes just the value of the variable you specify back to the caller of the function, it doesn't pass the actual variable name.

Try this: call the function with
$title = titlestring($give_this_to_fn)

best,
Eric

kycan

Thanks! Works like a charm! I thought it was a local variable issue, but I hadn't the slightest clue how to solve it.

Thanks again!

Anon

Also you might want your query to be:

$query = mysql_query ("SELECT title FROM content WHERE simplename LIKE '%$case%'");

Using '%$case%' will cause the search to find any record where $case is in the field simplename, no matter where it appears in the field.

polson

Also, read this :

http://www.php.net/manual/language.variables.scope.php