function error

[telsiin]

I am trying to pass a variable to a function, I believe my syntax is wrong

 

thank you for your help

 

 

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /../../../actiontest.php on line 7

 

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /../../../actiontest.php on line 9

 

5

6  function optionAction($actiontype){

7  mysql_select_db($database_actionrpg, $actionrpg);

8  $query_action = "SELECT * FROM actionlist WHERE actionlist.action_type = '$actiontype'";

9  $action = mysql_query($query_action, $actionrpg) or die(mysql_error());

10  $row_action = mysql_fetch_assoc($action);

11  $totalRows_action = mysql_num_rows($action);

12  }

13    optionAction("Attack");

14

15  ?>

 

[Alex]

You have a scope problem. $database_actionrpg is not defined within the scope of that function.

[flyhoney]

<?php

function optionAction($actiontype) {
global $database_actionrpg, $actionrpg;
mysql_select_db($database_actionrpg, $actionrpg);
$query_action = "SELECT * FROM actionlist WHERE actionlist.action_type = '$actiontype'";
$action = mysql_query($query_action, $actionrpg) or die(mysql_error());
$row_action = mysql_fetch_assoc($action);
$totalRows_action = mysql_num_rows($action);
}

optionAction("Attack");