mysql requests in php functions

[Anon]

hi,

does anyone know, wether one can write mysql requests in php functions???
i always get error messages like \"can not jump to result 0 on row 2\" or similar on requesting mysql through the function.
is there something special to do that it works or is it impossible???
please write me an answer.

El_Schubi

[Anon]

Not sure if this is what you meant, but look at mysql_data_seek() on the PHP website (http://www.php.net/manual/en/function.mysql-data-seek.php)

HTH

glj

[Anon]

no that's not what i mean..
i'm trying to create create a function like this:

function locate_user()
{
$sqlab = "select * from planetlist where";
$sqlab .= " owner = '$username'";

$res = mysql_db_query("onlinegame", $sqlab);

$plposgal = mysql_result($res, 0, "planetpgal");
$plposson = mysql_result($res, 0, "planetpson");
$plpossnum = mysql_result($res, 0, "planetpsnum");
}

when i use this function i got mysql failures.
when i use the code without a function it works perfectly.

so maybe anyone know why...

El_Schubi

[Anon]

Sorry, mis-understood completley!
I can only suggest that you put debugging messages in the file e.g.

$res = mysql_db_query("onlinegame", $sqlab);
print("Query has been run");

to pin-point exactly which line is going wrong.

If it runs ok out of the function it would suggest that maybe some variables are being used in the function that aren't accessible to it (although I can't see what it could be).
What does the function actually do? If this if the whole function, it doesn't return anything, so are you maybe trying to use the variables $plpos* out of the function, when they would not be available?

glj

[Anon]

the failures are in the 3 mysql_result lines.
it must be something else, because the code written without a function works. i also tried it with return $variable. but i got the same failure. the error messages are exactly:
warning: unable to jump to row 0 on mysql result index 3 in <apache dir> on line (..)

(..) = the line of the mysql_result query.

i get this error message 3 times for the 3 queries.

El_Schubi

[Anon]

Sorry am out of ideas 🙁

The site suggest that you not use mysql_result anyway for performance reasons, and that you should use maybe mysql_fetch_array() to get the fields.

Quote from an user comment on the PHP website:

Usually you'll use something like mysql_fetch_array because you'll be
interested in more than 1 cell at a time and it's inefficient to make
multiple calls back and forth to the database. Make 1 call
(fetch_arry/fetch_object) and then load from that
result data.

HTH, that's all I can offer I'm afraid

glj