[Resolved] Problem with custom function

[rob76]

I'm having problems executing the code in this function. The code works but when I encapsulate it and call the function select_news('main_news') , it doesn't work. Could anyone help please?

function select_news($news_table){

global $url_page_num,$conn;

$result= mysql_query("SELECT id,company_id,title,DATE_FORMAT(date, '%D %M %Y'),country,article,main_image,image_align FROM $news_table WHERE id=$url_page_num",$conn);

while ($row = mysql_fetch_array($result))   

{ $id =  $row['id'];
  $company_id =  $row['company_id']; 
  $title =  $row['title'];
  $date =   $row['3'];
  $news_country =$row['country'];
  $article =$row['article'];
  $main_image =  $row['main_image'];
  $image_align=$row['image_align'];

$title=trim($title);

return;
}

[mtmosier]

The variables you're setting in this function (id, company_id, title, etc) are local to the function. The calling code cannot access them.

You could declare them all global (generally considered bad), or you could put them into an array or object which you would return from the function.

[Roger_Ramjet]

Or make them session vars so that they are available throughout the project from script to script. I'd pass the $url... that way as well.

[rob76]

OK, thanks for your help on this