my PHP is bieng mean to my HTML

dachef

Hello,

Thanks in advance for any help provided.

Ok this is driving me crazy, i don't know if its a php problem, or an html problem..but they are related.

i have a table, 3 columns. in the column on the right i have my php script. wich goes into a database and retrieves information. the table where the information resides is long, so i on the page i only show the first 7 using if/else statements in a while loops as follows:

$num = 0;
while ($row = mysql_fetch_array($result)) {
if ($num >= 7) {
return;
}
else {
$article_id = $row["article_id"];
$date = $row["date"];
$headline = $row["headline"];
$summary = $row["summary"];
$full_article = $row["full_article"];
$courtesy_of = $row["courtesy_of"];
$pic = $row["pic"];
$num = $num+1;

			//Print out the data
					echo "
						<img src=/news/images/bullet.gif width=10 height=10>
						$date
						<br>
						<font size=4 color=#FF9900>$headline</font>
						<br>			
						<i>$summary</i>
						<br>
						<br>
						<a href=/news/article.php?art=$article_id><i>more...</i></a>
						<br>
						<br>
						<br>
					";
				}
			}

now the problem is not with the php script. its this: if i were to show any less than the exact number (or greater) of rows from the table, all the html after the php script does not appear. you can understand my frustration im sure. If i show all the rows then the rest of the page shows up fine.

There has to be a reason. Thanks for any help.

Mike

lentin64

maybe if you just put the ".$something." in it, it would look:
$num = 0;
while ($row = mysql_fetch_array($result)) {
if ($num >= 7) {
return;
}
else {
$article_id = $row["article_id"];
$date = $row["date"];
$headline = $row["headline"];
$summary = $row["summary"];
$full_article = $row["full_article"];
$courtesy_of = $row["courtesy_of"];
$pic = $row["pic"];
$num = $num+1;

//Print out the data
echo "<img src=/news/images/bullet.gif width=10 height=10>\n".$date."\n \n".$headline." \n".$summary." \n \n \n<a href=/news/article.php?art=".$article_id.">more...</a>\n \n \n \n";
}

dachef

Im sorry, you lost me steven. What do you mean?

what is the ".$something" ?

matto

Your use of return; could be the problem:

if ($num >= 7)
{ 
	return; 
}

In this branch of the if-then-else, the index variable $num does not get increased.

if you want wo show 8 entries but the result still got some at $num > 7, the program keeps running into the "return" branch. this seems to behave strange. is it necessary to use this? I don't know the context of that snippet but I suggest you eliminate that; try to set a flag (eg a boolean) instead.

matto

sorry, forget the sentence "In this branch of the if-then-else, the index variable $num does not get increased.", comes from a dismissed idea. 😉

lentin64

actually, the $something is:
<?php
$something = "text";
echo "My Line of ".$something." has been completed";
?>

Anon

Hi,

I just wanted to say thanks guys for trying to help me out. Im sorry but you guys actually confused me even more, but its cool..i figured it out. I just removed the if-else statement used to just show 7 records and instead just modified the sql statement to return 7 records..thanks of your help though guys...matto you gave me the idea by asking me if i can just get rid of the return;

thanks
Mike