php BUG exterminator needed

[eddiembabaali]

I am tryng to write a small function that will extract pagecontent from a database and i am having problems with it.

I have checked and the dbconnect function, dbselect function are all working fine. Here is the code

#
#Function for getting page content from database
function pagecontent($filename) {
    include ("config.php");
dbconnect();
dbselect("$dbname");
$sql=mysql_query("SELECT * FROM sitecontent WHERE filename='$filename'");
 $row = mysql_fetch_array($sql);
 $pid=$row["pid"];
 $pagetitle=$row["pagetitle"];
 $bodytext=$row["bodytext"];
 $section=$row["section"];
 $pageheading=$row["pageheading"];
 $filename=$row["filename"];

return $pagetitle;
return $bodytext;
return $section;
return $pageheading;
return $filename;

 }// end function getpagecontent 

I want to call this function at the top of each page and supply a filename like this

pagecontent("homepage");
echo "$bodytext";
echo"<h4>$pageheading</h4>"; 

The code stops to work only when I make it a function ..I really would not like to write all that code at the beginning of each page .. Any ideas why these values will not get returned by the function ?

Thanks in advance

[freddydoesphp]

Yes you can't return multiple items from a function, unless you return an array.

#
#Function for getting page content from database
function pagecontent($filename) {
    include ("config.php");
dbconnect();
dbselect("$dbname");
$sql=mysql_query("SELECT * FROM sitecontent WHERE filename='$filename'");
 return mysql_fetch_array($sql);
 }// end function getpagecontent

$pc = pagecontent("homepage");
echo $pc['bodytext'];
echo "<h4>".$pc['pageheading']."</h4>"; 

You could do this though

[redemption]

i'm not entirely familiar with PHP but you usually can't make a function return multiple times... only 1 object can be returned from a function so i guess that's where your code went wrong...

see you didn't actually need a PHP bug exterminator...

[eddiembabaali]

Thanks a bunch Freddy. I was getting desperate and entered all those returns... Its all working well now you are my hero!