Is their anything wrong during displaying?

[ramu_rp2005]

I'm unable to display any field.

while($i<$num)
  {	
	//echo"<font color=black><center>len1 value is $len1</center></font>";
  	$streamname=mysql_result($result,$i,"stream_name");
//	echo"<font color=black><center>$i streamname is $streamname</center></font>";
	$videopid=mysql_result($result,$i,"video_pid");
	$audiopid=mysql_result($result,$i,"audio_pid");
	$vprognumb= mysql_result($result,$i,"video_prgm_num");
	$pcrpid=mysql_result($result,$i,"pcr_pid");
	$videotype=mysql_result($result,$i,"video_type");
	$audiotype=mysql_result($result,$i,"audio_type");
	$aspectratio=mysql_result($result,$i,"video_aspect_ratio");
	$framerate=mysql_result($result,$i,"video_frame_rate");
	$chromaformat=mysql_result($result,$i,"video_chroma_format");
	$samplerate=mysql_result($result,$i,"audio_sr");
	$resolution=mysql_result($result,$i,"video_resolution");
//	echo"<font color=black><center>resolution is $resolution</center></font>";
	$directory=mysql_result($result,$i,"stream_location");
	$bitrate=mysql_result($result,$i,"stream_mux_bitrate");
        	$j= $i;
        	$j=$j+1;
	echo "<font size=3><tr bgcolor=$bgc><td>$j</td>";

for($g=0;$g<$len1;$g++)
{
//echo"<font><center>the field value is $field</center></font>";

	if($fields[$t] == "stream_name")
	{
	   echo "<td>$streamname</td>";
	}
	elseif($fields[$t] == "video_resolution")
	{
	   echo "<td>$resolution</td>";
	}
	elseif($fields[$t] == "video_pid")
	{
	   echo "<td>$videopid</td>";
	}
	elseif($fields[$t] == "audio_pid")
	{
	   echo "<td>$audiopid</td>";
	}
	elseif($fields[$t] == "pcr_pid")
	{
	   echo "<td>$pcrpid</td>";
	}
	elseif($fields[$t] == "video_type")
	{
	   echo "<td>$videotype</td>";
	}
	elseif($fields[$t] == "audio_type")
	{
	   echo "<td>$audiotype</td>";
	}
	elseif($fields[$t] == "video_chroma_format")
	{
	   echo "<td>$chromaformat</td>";
	}
	elseif($fields[$t] == "video_aspect_ratio")
	{
	   echo "<td>$aspectratio</td>";
	}
	elseif($fields[$t] == "audio_sr")
	{
	   echo "<td><center>$samplerate</center></td>";
	}
	elseif($fields[$t] == "video_frame_rate")
	{
	   echo "<td>$framerate</td>";
	}

}  // end of for.
echo "<td><center>$bitrate</center></td>";
echo "<td>$directory</td>";
echo "<td><a href=\"details.php?directory=$directory&streamname=$streamname&prognumb=$vprognumb&videopid=$videopid&audiopid=$audiopid&pcrpid=$pcrpid&\" target=main>Click Here 	

	</a></td></tr></font>";

if ($i%2==0)
{
	$bgc="gray";
}
else
{
	$bgc="black";
}
$i++;
   }   // End of while.

[Blulagoon]

Where do you initially set $i and $num, because if $i is always more than $num the while loop will never be activated and not a lot will happen.

Blu

[ramu_rp2005]

$i is set just above the while as $i=0; and the $num is the no. of rows got from query execution, $num=mysql_numrows($result); I'm displaying the $num value and it shows 6.So their are 6 rows.no problem about that. My problem is the values are not displaying. and why is that. Is my code wrong anywhere?

[Blulagoon]

Although it still works, mysql_numrows is deprecated and you should use mysql_num_rows

[ramu_rp2005]

I did it and nothing changed.

[Blulagoon]

Also, you've commented out echo statements on lines 5 and 17 of the code snippet you posted, what happens if you uncomment these, do they print to screen ? I would wonder, as you seem to be setting $streamname as an array.

Blu

[ramu_rp2005]

yeah, i just uncommented it and its displaying all the values.

[Blulagoon]

If you are trying to do what I think you are trying to do, I'd code it rather differently.

$result=mysql_query($query);   // runs your query whatever that is
while ($row=mysql_fetch_assoc($result)  {
$streamname = $row['streamname'];
$videopid = $row['videopid'];
$audiopid = $row['audiopid'];

// etc etc. This is assuming that you have columns in your 
// db called streamname, videopid, audiopid etc 

HTH - Blu

[ramu_rp2005]

i'm sorry. same... no display.I just dont understand why is this happening.No idea... fully blank

[Blulagoon]

Where does $fields and $t come from ?