[SOLVED] Help using php variables, in mysql query, in a php function

[spraypray12]

Heres my code

 

function grabit()
{

			$mySQL_query2 = "SELECT Requestor FROM ordrfrm WHERE id LIKE" . " $id";
			echo "<pre>\n$mySQL_query2\n</pre>";
			$f = mysql_query($mySQL_query2);
			while($row = mysql_fetch_assoc($f))
{
    echo "Name :{$row['Requestor']} <br>";
    }
   }
grabit();
echo $id

 

When i take this code out of a function, it works fine and gets me the results. It's the firsts steps for a little bit bigger function i'll build later, bit i  can't get this one working. Any Suggestions?

[trq]

You need to pass the id variable into the function. Your definition would look more like....

 

function grabit($id)

 

then to call it, use....

 

grabit(4);

 

Take a look at the manual at the use of functions.

[spraypray12]

Thanks, wassn't sure i needed to pass the variable, makes sense now that i think about it.

I'll remember that one