Welcome to WebmasterWorld Guest from

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

mysqli and a mysql procedure call

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

3:40 pm on May 20, 2012 (gmt 0)

Junior Member

5+ Year Member

joined:Mar 26, 2008
posts: 127
votes: 0

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 |

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>";
if ($mysqli=more_results($conn))

<td><a href ="card.php?id=$ego">$volume</a></td>
echo $catinfo;
}//if result
// }//do whle

while ($row=$result->fetch_row);

} //if statement if query
{echo "whiskey tango foxtrot";}

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.
10:58 pm on June 1, 2012 (gmt 0)


WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
votes: 0

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

Wrong call?