while loop in a function

[The Geek]

Think you want something like this:

PHP Code:

function fetch_hook($hook_name)
{
  $gethook = mysql_query("SELECT * FROM hooks WHERE hook_name = '$hook_name' ");
  $return = array();
  while($hook = mysql_fetch_array($gethook))
  {
      $return[]= $hook['phpcode'];
  }
  return $return;
} 


for a more vb3.5 approach (with cleansing, etc...) try this:

PHP Code:

 
function fetch_hook($hook_name)
{
  global $db;
  $hooks = $db->query_read("SELECT phpcode FROM hooks WHERE hook_name = '" . $db->escape_string($hook_name) . "' ");
  $return = array();
  while($hook = $db->fetch_array($hooks))
  {
      $return[]= $hook['phpcode'];
  }
  $db->free_result($hooks);
  return $return;
} 


Havent tested either - but they should work fine for you.

nJoy