php variable in html table

slrobinson1983

hello all. i am trying to insert a variable into my html table that will give the proper calculations for each row but it only returns 1 value that it repeats for every row. what am i doing wrong? here is the code...

<?php
mysql_connect("localhost", "root") or
die ("Check your server connection.");
mysql_select_db("uma");
$query="select * from tracks";
$result = mysql_query($query) or die(mysql_error());

$tracksum = mysql_query ("select sum(5s+4s+3s+2s+1s) from tracks");
		list ( $tracksum ) = mysql_fetch_row ( $tracksum ) or die (mysql_error());

$avgformula	= ("sum(((5s*5)+(4s*4)+(3s*3)+(2s*2)+(1s*1))/(5s+4s+3s+2s+1s))") or die (mysql_error());
$avgrating = mysql_query ("SELECT rap_name, $avgformula as occurrences from tracks group by rap_name order by occurrences desc, date_added desc") or die(mysql_error());
		list ( $avgrating ) = mysql_fetch_row ( $avgrating ) or die (mysql_error());

$avgratingNO = mysql_query ("SELECT $avgformula from tracks where rap_name='$avgrating'") or die(mysql_error());
		list ( $avgratingNO ) = mysql_fetch_row ( $avgratingNO ) or die (mysql_error());

?>

<table name="allmcs" id=allmcs cols=5 border=1 align="center" cellpadding="2" cellspacing="1" class="sortable" >
<tr>
<th><div align="center" class="tablefont">Track Title</div></th>
<th><div align="center" class="tablefont">Artist</div></th>
<th><div align="center" class="tablefont">No of Votes</div></th>
<th><div align="center" class="tablefont">Avg Rating</div></th>
<th><div align="center" class="tablefont">Date Added</div></th>
</tr>

  <span class="tablefont">

<?php  

while($row=mysql_fetch_array($result))
{
echo "<tr>";
echo "<td align=left>" . $row['track_title'] . "</td>";
echo "<td align=left>" . $row['rap_name'] . "</td>";
echo "<td align=right>" . $tracksum . "</td>"; //reserved for total track votes
echo "<td align=right>" . $avgratingNO . "</td>"; //reserved for average track rating		
echo "<td align=right>" . date('m-d-Y', strtotime($row['date_added'])) . "</td>";
echo "</tr>";
}
echo "</table>";
?>

bradgrafelman

When posting PHP code, please use the board's [noparse]

...

[/noparse] bbcode tags as they make your code much easier to read and analyze.

As for your problem, it should make sense that neither $tracksum nor $avgratingNO change for any of the rows since you only execute their respective queries once and retrieve the results once (both outside of the while() loop).

slrobinson1983

ok im following you (again im new so bear with me) but the table is running a while statement already so how do i position the new while statement so that it executes on the single column but dosent interfere with the original while statement. i tiried playing with it and i inserted my new while statement into the curly brackets of the previous one and it screwed up my columns.

slrobinson1983

hey all. i finally got the answer i was looking for. here is the code for anyone interested...

<?php
while($row=mysql_fetch_array($result))
{
echo "<tr>";
echo "<td align=left>" . $row['track_title'] . "</td>";
echo "<td align=left>" . $row['rap_name'] . "</td>";
//reserved for total track votes
$total=$row['5s']+$row['4s']+$row['3s']+$row['2s']+$row['1s'];
echo "<td align=right>" . $total . "</td>"; 
//reserved for average track rating
$total2=((5*($row['5s']))+(4*($row['4s']))+(3*($row['3s']))+(2*($row['2s']))+(1*($row['1s'])))/$total;
echo "<td align=right>" . $total2 . "</td>"; 
echo "<td align=right>" . date('m-d-Y', strtotime($row['date_added'])) . "</td>";
echo "</tr>";
}
echo "</table>";
?>