I have tested out my procedure on my home machine. It woks pretty well

I know there is output from the sql.

Now I want to try it out on the host. It gives no output.
Here is my php code

    $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 would appreciate any assistance I can get here.

Recommended Answers

All 3 Replies

Are you sure you copied everything to your database ?

Is there a reason you use multi query for a single stored procedure call ?

Is there a reason you use multi query for a single stored procedure call ?

A single stored procedure could return multiple result

@baruchM Have you test your hosted stored procedure in MySQL client application like PhpMyAdmin, Adminer, Mysql Workbench, or other?

A single stored procedure could return multiple result

That's not what that function is for.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.