Getting null in fetching high values from mysql table.

[rajeshkr]

Hi, I am using a code to fetch values from the database using php code in Html format. but i am facing a problem while fetching table having more than 1000 rows that giving the result "Null", but for lesser rows table this code working fine.
Here is the code...
<?php
include("repo_db.php");
$query=mysql_query("Select * from tbl_coupons") or die(mysql_error());
if(!$query) { mysql_close();
echo json_encode("There was an error running the query: " . mysql_error());
}
else if(!mysql_num_rows($query))
{
mysql_close();
echo json_encode("No result return!");
}
else
{
$header = false;
$output_string = "Production Details By Customer Name"; $output_string .= "\n";
while($row = mysql_fetch_assoc($query))
{
if(!$header)
{
$output_string .= "\n";
foreach($row as $header => $value) { $output_string .= "{$header}\n";
}
$output_string .= "\n";
}
$output_string .= "\n";
foreach($row as $value)
{
$output_string .= "{$value}\n";
}
$output_string .= "\n";
}
$output_string .= "\n";
}
mysql_close();
// This echo for jquery
echo json_encode($output_string);
?>
Can anyone suggest the problem solution.
Thanks

[planetsim]

Im surprised with the NULL response, I would have expected some sort of memory limit error. However the issue is you are trying to return too many records from the database, you need to look into pagination and probably change your output code to handle this so your requests can pull additional pages. You can do a search on this forum for the many pagination questions.

On a side note, is there a reason you're JSON encoding a string ?