Function Help

[phpretard]

How can I convert the code below in a funtion.

 

I then need to call it out and see the results.

 

echo"<select name='SiteArea'>";
$resultshape = mysql_query("SELECT * FROM shape");
while($row = mysql_fetch_array($resultshape))
{
$id=$row['id'];
$name=$row['name'];
echo "<option value='$name'>$name</option>";
}
echo "<select>";

 

Any help today?

 

-Anthony

[kishan]

function getResponse()

{

global $db;

echo "<select name='SiteArea'>";

$resultshape = mysql_query("SELECT * FROM shape");

while($row = mysql_fetch_array($resultshape))

{

$id=$row['id'];

$name=$row['name'];

echo "<option value='$name'>$name</option>";

}

echo "<select>";

}

 

 

call like :$res=getResponse();

[phpretard]

Thank you...I have much to learn.

 

PS. What is global $db;

 

[Andy-H]

It makes your db connection variable scope global, therefor you don't need to connect to your database in the function.

[phpretard]

So if my conection was var $con then it would be: global $con ?

[Andy-H]

yeh

[DarkWater]

But, alas, you never want to use global.  Pass the connection resource into the function if you need to use it (in this case, you don't need the db connection inside the function anyway, lol).