Display from mysql database

john9292

Hello, with this code the subject column is always the same when it should be different i.e. different entries in the database.

Please help

<?php
	$sql = "SELECT * FROM javaForum";
	$result = mysql_query($sql)
		or die ("Couldn't perform query $sql <br />".mysql_error());
	$row = mysql_fetch_array($result);
	$nrows = mysql_num_rows($result);

for ($i = 0; $i < $nrows; $i++)
{
	echo "<tr>";
	echo "<td height='40' width='85'><font color='white'>";

	echo "$row"; //I think this has to be moved although I dont know where to

	echo "</font></td>";

	echo "<td height='40' width='85'><font color='white'><p align='center'>2</p></font></td>";
	echo "<td height='40' width='85'><font color='white'><p align='center'>3</p></font></td>";
	echo "<td height='40' width='85'><font color='white'><p align='center'>4</p></font></td>";
	echo "<td height='40' width='85'><font color='white'><p align='center'>5</p></font></td>";
	echo "</tr>";
}


echo "</table>";
echo "</p>";
?>

tjohnson_nb

How many fields are there in the javaForum table? You will need to put the 'fetch'
inside the for loop like this ;

    for ($i = 0; $i < $nrows; $i++)
    { 
    $row = mysql_fetch_array($result);

john9292

Yes that works - cheers.

One more question - im using this php script to control the heading of the submit page.

<?php
	session_start();
	if($_SESSION['forumType'] = "Java")
	{
		$_SESSION['submitType'] = "Java";
		header("Location: submit.php");
	}

if($_SESSION['forumType'] = "PHP")
{
	$_SESSION['submitType'] = "PHP";
	header("Location: submit.php");

}
?>

I use this in my phpforum

$_SESSION['forumType'] = "PHP";

To show what where the user came from

The heading is displayed like this in submit.php:

<table>
<tr background='Fade2.gif'>
<th>
<?php
	echo $_SESSION['submitType'];
?>
&nbsp;forums</th>
</table>

This only ever gives PHP forums as the heading though.

Any ideas would be appreciated.

Thank you

john9292

This has been solved - it needed "==" instead of "=" when comparing the session.