Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Unable to display more than 25 records
May 10, 2006, 11:58 pm
rate this thread
script to return/display more than 25 records:
$query = "SELECT company_name, company_phone FROM tbl_company
ORDER BY company_name LIMIT 40 ;";
$result = mysql_query($query, $db); //note $db connection already
for ($i=0; $i < $totalRows; $i++)
$row = mysql_fetch_assoc($result);
echo "...";// show info here etc.
When I use PHPMyAdmin and run the above SQL statement direct, it
returns all 40 records. However when running on the host server, my
script is generating and displaying only the first 25 records on my
I'm at a loss here.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum