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
}
?>