mysql_affected_rows help

viper21634

well, I need some ideas, I am running my sql connection and query from a function. Now, I need to be able to get the rows changed, but here is the thing, I am using the return to send $result from the SQL statement. Now correct me if I am wrong, but there is no way to return more than one thing, and no way to access vars set in the function. So, how can I use mysql_affected_rows, it needs the conn ID so I cant figure it out. Any ideas??

PS. for a board admin, is there any way I can get my username changed?? if you can do it I would like it changed to aBs0lut3-ZeRo

tomhath

Now correct me if I am wrong, but there is no way to return more than one thing

You're wrong (sorry, you asked for it) 😉

Look at the second example here:

http://www.phpbuilder.com/manual/functions.returning-values.php

viper21634

here is the problem

    require ('config.inc.php');
    $uconn = mysql_connect($dbserver,$usname,$passw) or die("Could not connect to the database");
    mysql_select_db($db) or die("Could not select the database $db");
    //I am returning the strait query value, so I dont want to mess with that. 
    $result = mysql_query($sql,$uconn);
    return $result;
    mysql_close($uconn);

Because I am returning the raw query result so I can do what ever I need to with it. for example in one spot I use it to make a array, in a nother I will just dump it to the client. so I just cant figure how to send the affacted rows outside the function.

I am calling it like this
$result = user_sql($sql,$db,$usname,$passw);

diego25

First of all, you should put the mysql_close BEFORE the return statement. 'cause if you have it after, it will never run mysql_close()! You could argue that PHP would clean it up automatically eventually, but still, it's better to have clean code 🙂

Now, for your problem. It's true, you cannot return 2 values, BUT you can return an array of values. Therefore, put $result and the number of affected rows into an array, and then return that array.

Diego

viper21634

hmmmm, I really didnt think that would work, but it works fine. Thanks guys, now I have a really DUMB question, I got it working one time but it isnt working now. for example

if (isset($loggedin))
{
echo "just testing";
echo "<a href=".$PHP_SELF."?dosomething>GO here</a>";
}
if (isset($loggedin))
{
if (isset($HTTP_GET_VARS['dosomething']))
{
echo "just testing again";
}

never mind, I just saw what the problem is 😃 I new it was stupid.

Thanks Guys