homepage Welcome to WebmasterWorld Guest from 54.197.108.124
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
mysqli and a mysql procedure call
empty output to php, but it should have a long output list from mysql
Baruch Menachem




msg:4455587
 3:40 pm on May 20, 2012 (gmt 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 |
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




msg:4460627
 10:58 pm on Jun 1, 2012 (gmt 0)

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


Wrong call?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved