0

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.

3
Contributors
3
Replies
8
Views
5 Years
Discussion Span
Last Post by pritaeas
0

Are you sure you copied everything to your database ?

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

0

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?

Edited by indraginanjar

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.