Page wont display all data

[treds1]

i am trying to display all the data from a news table, however, when it will only display the first three entries. But if i limit the outpu tof the main text body usign

echo substr($myrow['news_body'], 0, 100);

it displays all the records

is there a limit to how much i can display??

Seems odd to me.

Any ideas

Cheers

Nick

//code

include 'dbcon.php';

	echo "<h1>NEWS</h1><br>";


	//SQl statement for db query

	$result=mysql_query("SELECT * FROM news",$db);


	while($myrow = mysql_fetch_array($result))
           {

		echo substr($myrow['news_date'], 6, 2), "/";
		echo substr( $myrow['news_date'], 4, 2 ), "/";
		echo substr( $myrow['news_date'], 0, 4 );

		echo "<br><br><b>";
		echo $myrow['news_subject'];
		echo "</b><br><br>";
		echo $myrow['news_body'];
		echo "<br>";

		echo "<hr>";
	}

[bogu]

Did you try to put this query :

SELECT * FROM news

into your PhpMyAdmin to see what it is showing you.
if there is ok see if there ar no html tags or special chars like:

 < > \ '  " etc.

And try the view source to see there what hapend.

Hope this helps.

[treds1]

yeh i can retrive all of the data just does not display it ive run a row count on the records recieved and i revieve all teh records, it just does ot display thm all

[bogu]

See view source from your browser and probably is there but you have some html tags that is interpreted by browser.

Try using htmlspecialchars() function, from php.

[treds1]

Have allready checked that and its not there

it does not make sence to me

[bogu]

Give me a copy paste of your text from a news to see how it looks like.

[bogu]

If you dont whant to show me the text than try this:

echo htmlspecialchars($myrow['news_body']); 
echo htmlspecialchars($myrow['news_subject']);

[treds1]

sorry only just checked back i sorted out the problem, it was somethign to do with the fact that i wass trying to add an image with the news, but ive got it sorted

cheers for your help

Nick