Welcome to WebmasterWorld Guest from 54.145.173.147

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)

5+ Year Member



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

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



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


Wrong call?