Page 1 of 1

problem in fetching results

Posted: Thu Jan 17, 2008 6:52 am
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

Re: problem in fetching results

Posted: Thu Jan 17, 2008 8:04 am
by yacahuma
what is inside your SP? Is it small to post it here? Are there any updates being made in the SP?