why this query doesnt work in a function??

[goaman]

Hi guys,
I'm having little problem here updating mysql tables.. the query works normally when it's outside the function but it doesn't run when it's inside the function. I want to know whats wrong with it.. I'm kida stuck here.. please let me know so I can continue coding..

//example

<?php
include 'dbconnect.php';

$ID = 1;

function Boo()
{

//UPDATE NOW...........................
$update = mysql_query("UPDATE foo SET bar = 'TEST9' WHERE id = '$ID'");

echo 'Cool';

}

//when you execute the function.. it will echo cool, but no updates! :(
Boo();

?>

TIA

[laserlight]

$ID is not in the scope of the function. You should pass it to the function as an argument.

<?php
include 'dbconnect.php';

$ID = 1;

function Boo($ID)
{
	//UPDATE NOW...........................
	$update = mysql_query("UPDATE foo SET bar = 'TEST9' WHERE id = '$ID'");

echo 'Cool';
}

//when you execute the function.. it will echo cool, and updates
Boo($ID);

?>

[goaman]

oh.. yea.. I see the problem now.. 🙂

thanks for the fast reply laserlight, you rock 🙂