Search the Community
Showing results for tags 'limit'.
-
It's getting frustrating having to wait on the timer before being allowed to proceed the search on the forum for answers for my coding problems. I understand it's a measure against bots/server flooding, but isn't it better options around that doesn't put so strict limitations on us users?
-
why these lines are not working? $sql3 = "SELECT *,sum(amt),sum(qty) FROM purchase WHERE sid=$sid AND pvn!=0 ORDER BY pvn DESC LIMIT 2";$result3 = mysqli_query($connect, $sql3) or die(mysqli_error($connect));$row3 = mysqli_fetch_array($result3);echo $row3['sum(qty)'] . "<br />";$sql4 = "SELECT *,sum(amt),sum(qty) FROM purchase WHERE sid=$sid AND pvn!=0 ORDER BY pvn DESC LIMIT 3";$result4 = mysqli_query($connect, $sql4) or die(mysqli_error($connect));$row4 = mysqli_fetch_array($result4);echo $row4['sum(qty)'] . "<br />"; they both SELECT result from the complete rows on 'purchase' table. please guide what is wrong in it!