[SOLVED] I'm new to functions

[almightyegg]

I have just written one but I'm not sure how to start it going....

 

It's not one that echoes anything, so I don't echo it out. How else would I start it up??

[pocobueno1388]

Well...post your function code.

 

If it just returns a value, you could assign it to a variable.

 

$var = myfunc();
echo $var;

[almightyegg]

It doesn't return anything really....

 

function Update($rid) {
while($rid <> 0) {
        $update = mysql_query("UPDATE topics SET updatetimestamp='$timestamp' WHERE fid='$f' and id='$rid'");
$sel = mysql_fetch_array(mysql_query("SELECT * FROM topics WHERE fid='$f' and id='$rid'"));
$rid = $sel[rid];
}
}

 

just does Updates Mysql

[Jessica]

You mean how to call it?

Update($value);

[almightyegg]

Can I literally just call it:

Update($value);

 

Nothing before/after it???

[rarebit]

There's other variables in there that aren't declared/set. You might want to use the 'global' function:

function Update($rid)
{
global $timestamp, $f;
while($rid <> 0) {
        $update = mysql_query("UPDATE topics SET updatetimestamp='$timestamp' WHERE fid='$f' and id='$rid'");
$sel = mysql_fetch_array(mysql_query("SELECT * FROM topics WHERE fid='$f' and id='$rid'"));
$rid = $sel[rid];
}
}

These will still need to be set external to the function. Also you might want to return a result to indicate success or failure.

Here's a wrapper I use:

function _db_do_mysql_query($s, $conn)
{
try
{
	if ( !@ ($res = mysql_query($s, $conn)) )
		throw new Exception (mysql_error());
}
catch (Exception $e)
{
	//echo 'ERROR: ' . $e->getMessage();
	return array(-1, $res);
}
return array(0, $res);
}

[almightyegg]

Thanks, I got it working