Can't understand why my function won't work...

[ibanez270dx]

Hi everyone,

  It's been awhile since I've coded in PHP and I can't figure out whats wrong with my code... I have a simple function to grab a field from my database and return it. I can make it work without the function, but when I implement it as a function, it breaks - no error, just a blank page.

 

This works fine:

$page = "page_about";
$sql = "SELECT body FROM " . $page . " WHERE id=1";
$result = @mysql_query($sql,$connection) or die(mysql_error());
$row = mysql_fetch_array($result);
$display = $row[0];

But this does not:

function grabBody($page)
{
$sql = "SELECT body FROM " . $page . " WHERE id=1";
$result = @mysql_query($sql,$connection) or die(mysql_error());
$row = mysql_fetch_array($result);
return $row[0];
}
$display = grabBody("page_about");

 

If anyone has any idea whats wrong, please let me know!!

 

Thank you,

  - Jeff Miller

[PFMaBiSmAd]

You should be developing and debugging php code on a system with error_reporting set to E_ALL and display_errors set to ON so that all the php detected errors will be reported and displayed. You will save a ton of time.

[DavidAM]

Also remove the '@' sign and erase it from your memory.  Hiding errors does not help you.

 

The error you should see is that $connection is not defined. It might be defined outside your function but it is not defined inside the function.

[ibanez270dx]

Ah, thanks you guys!

 

I enabled display_errors and, as predicted, got the error about $connection not being defined within the function.

 

Thanks again, I appreciate the help!

- Jeff