problem in fetching results

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
itsmani1
Forum Regular
Posts: 791
Joined: Mon Sep 29, 2003 2:26 am
Location: Islamabad Pakistan
Contact:

problem in fetching results

Post by itsmani1 »

Hello all

Please see this code, when i try to call this procedure with command line i get 3 results but when i call it on page i don't get any result, and other issue is i don't get any error or warning as well.

any help???

Code: Select all

 
<?PHP
    $catId = $_GET["id"];
    $mysqli = connection1();
    $adsList = "call zselectClassifieds(2)";
    $query  =$mysqli->query($adsList);
    while($data = $query->fetch_row())
    {
?>
          <tr>
            <td><a href="classified.php?id=<?PHP echo $data[1]; ?>">0000<?PHP echo $data[0]; ?></a></td>
          </tr>
<?PHP
}
?>
 
thank you
User avatar
yacahuma
Forum Regular
Posts: 870
Joined: Sun Jul 01, 2007 7:11 am

Re: problem in fetching results

Post by yacahuma »

what is inside your SP? Is it small to post it here? Are there any updates being made in the SP?
Post Reply