why does UPDATE not work here?????

[rayk]

function nextEvent($dbname, $nextevent)
{
global $link;
if(!$link)
die("Couldn't connect to MySQL");
mysql_select_db($dbname, $link)
or die("Couldn't open $section: ".mysql_error());
$result = "UPDATE members WHERE username=$username SET nextevent = '1'";
mysql_query($result);
}

it does not want to update the mysql database at all. It does not give me any errors either 🙁

[yelvington]

Where are $username and $section set? The PHP rules on variable scoping dictate that those variables will be unset in the context of a function, unless you specifically import them by declaring them as global or by passing them as arguments in the function call.

[rayk]

oops, i rewrote the code here wrong...this is what I have:

function nextEvent($dbname, $username, $nextevent)
{
global $link;
if(!$link)
die("Couldn't connect to MySQL");
mysql_select_db($dbname, $link)
or die("Couldn't open Members: ".mysql_error());
$result = "UPDATE members WHERE username=$username SET nextevent = '1'";
mysql_query($result);
}

I copied and pasted this stuff now.

[mrmufin]

Try something like:

function nextEvent($dbname, $username, $nextevent) { 
	global $link; 
        if(!$link) die("Couldn't connect to MySQL"); 
	mysql_select_db($dbname, $link) or die("Couldn't open Members: ".mysql_error()); 
	$result = "UPDATE members SET nextevent=1 WHERE username='$username'"; 
	mysql_query($result); 
} 

Which would set the nextevent to 1 where the username='some user name'. Or... if you're trying to set the username based on the next event, your query should like:

"UPDATE members SET username='$username' WHERE nextevent=1";

In other words, your query is all buggered up.