PHP call a function from a function

Question

What's the PHP code that would do one thing first and then take that and do a second.

1st: I want $_GET a variable and then run a query on it and return variables.

AND THEN

2nd: Use those "other" variables in a query.

I'm thinking I want to do this with two functions b/c my query is based off of what values I send from a form. So it has to get the values from the url and then run the query.

Answer 1

$variables = $_GET['variable'];

mysql_query("SELECT * FROM `table` WHERE `field` = '".mysql_real_escape_string($variables)."' LIMIT 20");

Do you want something like the above?

Answer 2

yes, generally you can call any method (= function) from within any other method.

function getVars($vars)
{
    foreach ($vars as $key => $value)
    {
        doSomethingWithMyVars($key, $value)
    }
}

function doSomethingWithMyVars($key, $value)
{
    $sql = 'SELECT this, that FROM mytable WHERE '.$key.' = '.$value;
    //get data
}

getVars($_GET);

but attention, this is just exemplary code, you probably won't do it like that. Also the query wouldn't work for strings. it's just an example of how to call functions from within functions based on what your task seems to be more or less.