homepage Welcome to WebmasterWorld Guest from
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

5+ Year Member

Msg#: 4455585 posted 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 |

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.



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

Msg#: 4455585 posted 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