Get the value returned by a function (mysql)

[Chiquito]

Hi. I am trying to get the value my function (mysql) returns in my php program and I couldnt't till now: PLEASE can anybody help me? Thanks a lot from now.

<?php
 
  $link = mysqli_connect('localhost', 'myuser', 'mypass', 'database') 
or die ('Error connecting to mysql: ' . mysqli_error($link));
 
  $mires=0;
  $result = mysqli_query($link, "select addtable('r',$mires)");
   while ($row = mysqli_fetch_assoc($result))
  {
   $myoutput= $row['myvalue'];
    echo $myoutput;
  }
?>

In my database

CREATE TABLE `mytable` (
  `idta` INTEGER(11) NOT NULL AUTO_INCREMENT,
  `nom` VARCHAR(20) COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`idta`)
 
)ENGINE=InnoDB
AUTO_INCREMENT=15 CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci';
 

The Function addtable in mysql is:

BEGIN
DECLARE xid integer;
INSERT INTO mytable ( nom)
SELECT pin AS Expr1;                   
set xid=LAST_INSERT_ID();
return myvalue;
END

THANKS A LOT!!

update:
I made a mistake, I put
$result = mysqli_query($link, "select addtable('r',$mires)");
instead of
$result = mysqli_query($link, "select addtable('r')");
but this was not my problem, that is, I am still in trouble with this.

[Rabbit]

Please use code tags when posting code.

In your PHP code, you're trying to access a field named 'myvalue' from your SQL. However, in your SQL, you don't have any fields called 'myvalue'. You have one field in your SQL, and that field has no name because you didn't give it an alias.

In your function code, you're returning a variable called 'myvalue'. But you never declare that variable nor do you ever assign it a value. So it's not going to return anything anyways.

[Chiquito]

The solution, here

$success = mysqli_query($conexion, "call AltaModinmue(0,0,$tipoinmue,@ide)");
 
    if (!$success){
        printf("mensaje Error: %s\n", mysqli_error($conexion));
    }
    else{ 
        $retorno = mysqli_query($conexion,"select @ide");
        $fila = mysqli_fetch_array($retorno);
        $clave = $fila[0];