Roster

cschotch

Heres another problem someone might be able to help me with.......I have a roster page on a website that pulls info from the MySql database that I have. I then lists everything for each individual. considering I have more then 30 plus people and more coming in it is getting rather long. I put a little javascript in the bottom right so they can go to the top of the page. With a static html page you can have a link on it that goes directly to that name on the same page using something like this:

<a href="#this goes to the other link"></a>
.....meanwhile farther down the page is the other link
<a href="this is where it ends up farther down the page"></a>

Now here is my php script for listing every persons data over and over again...pretty simple..

<?php

mysql_connect('localhost', 'username', 'password');
mysql_select_db('table');
$res = mysql_query("SELECT * FROM roster ORDER BY Alias");
while($row = mysql_fetch_object($res)) {
?> 
	<table width="100%" cellborder="1px" bordercolr="black" border="1px">
		<tr>
			<td width="130">Alias:
			</td>
			<td>
				<?php print $row->Alias; ?>
			</td>
		</tr>
		<tr>
			<td width="130">
				Name:  

			</td>
			<td>
				<?php print $row->Name; ?>
			</td>
		</tr>
		<tr>
			<td width="130">Age:
			</td>
			<td>
				<?php print $row->Age; ?>
			</td>
		</tr>		
		<tr>
			<td width="130">Hometown:
			</td>
			<td>
				<?php print $row->Hometown; ?>
			</td>
		</tr>
		<tr>
			<td width="130">E-mail:
			</td>
			<td>
				<?php print $row->Email; ?>
			</td>
		</tr>
		<tr>
			<td width="130">Favorite Side:
			</td>
			<td>
				<?php print $row->FavSide; ?>
			</td>
		</tr>
		<tr>
			<td width="130">Favorite Weapon:
			</td>
			<td>
				<?php print $row->FavWeap; ?>
			</td>
		</tr>
		<tr>
			<td width="130">Favorite Quote:
			</td>
			<td>
				<?php print $row->FavQuote; ?>
			</td>
		</tr>
                <tr>
			<td width="130" colspan="2"><br>
			</td>
		</tr>
	</table>
<?php
}
?>

..but when I try to do another while or for each statement before the original WHILE statement that lists all information for each team member it always gives me multiple parse errors.....I dont know what I would have to do differently.....heck i dont know if this is supposed to be the "right" way or if multiple foreach statements would go over well....

nnichols

suntra

cschotch is using "mysql_fetch_object()" not "mysql_fetch_array()" - so $row is an object NOT AN ARRAY!

cschotch

Please post the code for what you are trying to do (the code that was failing). Then we can have a go at figuring out what's wrong.

cschotch

ok heres what i got so far....

<?php include("headhtml.php");
?>
<body class="bdybgrd">
<table align="center" valign="top" class="maintable">
<tr>
<td>
<?php include("header.php");
?>
</td>
</tr>
<tr>
<td>
	<table>
		<tr>
			<td class="leftmenu"><?php include("leftmenu.php"); 
			?>
			</td>
			<td class="mainbdy">
<?php

mysql_connect('localhost', 'username', 'password');
mysql_select_db('table');
$res = mysql_query("SELECT * FROM roster ORDER BY Alias");
while ($row = mysql_fetch_object($res)) { 
    echo "<a href=\"#$row->Alias>";
    echo $row->Alias;
    echo "</a>";
}
?>
<?php

while($row = mysql_fetch_object($res)) {
?> 
	<table width="100%" cellborder="1px" bordercolr="black" border="1px">
		<tr>
			<td width="130">Alias:
			</td>
			<td>
				<?php print "<a href=\"$row->Alias>";
				print $row->Alias;
				print "</a>"; 
				?>
			</td>
		</tr>
		<tr>
			<td width="130">
				Name:  

			</td>
			<td>
				<?php print $row->Name; ?>
			</td>
		</tr>
		<tr>
			<td width="130">Age:
			</td>
			<td>
				<?php print $row->Age; ?>
			</td>
		</tr>		
		<tr>
			<td width="130">Hometown:
			</td>
			<td>
				<?php print $row->Hometown; ?>
			</td>
		</tr>
		<tr>
			<td width="130">E-mail:
			</td>
			<td>
				<?php print $row->Email; ?>
			</td>
		</tr>
		<tr>
			<td width="130">Favorite Side:
			</td>
			<td>
				<?php print $row->FavSide; ?>
			</td>
		</tr>
		<tr>
			<td width="130">Favorite Weapon:
			</td>
			<td>
				<?php print $row->FavWeap; ?>
			</td>
		</tr>
		<tr>
			<td width="130">Favorite Quote:
			</td>
			<td>
				<?php print $row->FavQuote; ?>
			</td>
		</tr>
                <tr>
			<td width="130" colspan="2"><br>
			</td>
		</tr>
	</table>
<?php
}
?>
                        </td>
		</tr>
	</table>
</td>
</tr>
<tr>
<td>
<?php include("footer.php");
?>
</td></tr>
</table>
</body>
</html>

Now what happens is once the script executes all it does is put all the names straight up against each other but the while loop never gets executed.....at least that is what it looks like....
heres the page after it executes...............
http://www.invisiblewarriors.com/rostertest.php
thanks for all the help

nnichols

I assume your done now. I just tried your link and it appears to be working ok.

Good job 😉

cschotch

actually I would like to format that into a little more then just straight down....got any ideas as to how i can either put each name into a sepearate <td> or anything??

nnichols

To put them all into a table you could use -

echo "<table>";
while ($row = mysql_fetch_object($res)) { 
echo "<tr><td><a href=\"#$row->Alias>";
echo $row->Alias;
echo "</a></td></tr>";
}
echo "</table>";

To put the list into two columns (or three) you need to loop through the results and store them in an array so you can access the rows by numeric index.

If you want to do this post back and I'll try to step up a gear and remember how to do it.

😉

cschotch

ok...looping....how would you loop through the first one...then stop then loop through the data for each player?
would you use a foreach or just continue using the while loops?