mysqli and a mysql procedure call

empty output to php, but it should have a long output list from mysql

[Baruch Menachem]

I have a nice little mysql procedure that in MySql on my terminal produces a large output.

mysql> call sought('men');
+---------------------------------------------------+---------------------+-----+------------+
| title                       | scribe       | id | subject  |
+---------------------------------------------------+---------------------+-----+------------+
| American Language                 | Henry Louis Mencken | 64 | Language  |
| H L Mencken Smart Set Critisicm          | Henry Louis Mencken | 431 | Journalism |
| Happy Days                    | Henry Louis Mencken | 116 | Biography |
| Heathen Days                   | Henry Louis Mencken | 25 | Biography |

etc.

I want to display this using mysqli... I can't get object style to run at all, and non object style runs, but produces no output...

$bob="call seeker($profound)";

if (mysqli_multi_query($conn,$bob))
  {
  echo "<hr>";
  echo "<table><th>Section</th><th>Author</th><th>Title</th>";
   do 
    {
    if ($mysqli=more_results($conn))
       {
       $thepot=$row['scribe'];
       $ego=$row['id'];
       $volume=$row['title'];
       $subject=$row['subject'];
       $catinfo=<<<MEOW
       
<tr>
<td>$subject</td>
<td>$thepot</td>
<td><a href ="card.php?id=$ego">$volume</a></td>
</tr>
MEOW;
echo $catinfo;
   $result->free();
       }
       }//if result
 //      }//do whle
      
    while ($row=$result->fetch_row);
             
    }  //if statement if query
    else 
    {echo "whiskey tango foxtrot";}
echo"</table>";

I know the procedure generates output.

Is this just totally a wrong use of a procedure?

I also have a view that produces the same output.

[coopster]

mysql> call sought('men');
$bob="call seeker($profound)";

Wrong call?