Bravo List - Error help please

Bravo List (http://www.bvlist.com/index.php)

- Mods & Themes (http://www.bvlist.com/forumdisplay.php?f=87)

- - Error help please (http://www.bvlist.com/showthread.php?t=9028)

Error help please

Strict Standards: Only variables should be passed by reference in /home/www/viewtickets.php on line 28

Strict Standards: Only variables should be passed by reference in /home/www/viewtickets.php on line 29

Strict Standards: Only variables should be passed by reference in /home/www/viewtickets.php on line 30

Strict Standards: Only variables should be passed by reference in /home/www/viewtickets.php on line 31

Strict Standards: Only variables should be passed by reference in /home/www/viewtickets.php on line 32

Strict Standards: Only variables should be passed by reference in /home/www/viewtickets.php on line 33

PHP Code:


		
			
<?

require "backend/functions.php";

dbconn();



$res = mysql_query("SELECT * FROM lottery_config") or sqlerr(__FILE__, __LINE__);

while ($arr = mysql_fetch_assoc($res))

$arr_config[$arr['name']] = $arr['value'];

$endday = $arr_config['end_date'];

if (!$arr_config["enable"])show_error_msg("Sorry", "Lottery is disabled.");

stdhead();

begin_frame("Users who Have Purchased Tickets");

print("<center><font color=red>Lottery Ends: </font><b>" . $endday . "</b></center>");

?>

<table align=center border="1" width="600" cellpadding="5">

<tr>

<td class="tabletitle">#</td>

<td class="tabletitle">User name</td>

<td class="tabletitle">Number of tickets</td>

<td class="tabletitle">Uploaded</td>

<td class="tabletitle">Downloaded</td>

<td class="tabletitle">Ratio</td>

</tr>

<?

$sql = mysql_query("SELECT user FROM tickets") or die (mysql_error());

while ($myrow = mysql_fetch_assoc($sql))$user[] = $myrow["user"];

$user = array_values(array_unique($user));

for ($i = 0; $i < sizeof($user); $i++){$tickets[] = mysql_num_rows(mysql_query("SELECT * FROM tickets WHERE user=$user[$i]"));

$username[] = end(mysql_fetch_row(mysql_query("SELECT username FROM users WHERE id=$user[$i]")));

$id[] = end(mysql_fetch_row(mysql_query("SELECT id FROM users WHERE id=$user[$i]")));

$uploaded[] = mksize(end(mysql_fetch_row(mysql_query("SELECT uploaded FROM users WHERE id=$user[$i]"))));

$downloaded[] = mksize(end(mysql_fetch_row(mysql_query("SELECT downloaded FROM users WHERE id=$user[$i]"))));

$ratio[] = end(mysql_fetch_row(mysql_query("SELECT downloaded FROM users WHERE id=$user[$i]")));

$ratio2[] = end(mysql_fetch_row(mysql_query("SELECT uploaded FROM users WHERE id=$user[$i]")));

echo "<tr><td class=tableb>" . ($i + 1) . "</td>

<td class=tableb><a href=account-details.php?id=$id[$i]>$username[$i]</a></td>

<td class=tableb>$tickets[$i]</td>

<td class=tableb>$uploaded[$i]</td>

<td class=tableb>$downloaded[$i]</td>

<td class=tableb>" . number_format($ratio2[$i] / $ratio[$i], 3) . "</td></tr>";

}

?>

</table>

<?

print("<center><h3><a href=games.php>Back to Casino</a></h3></center>");

end_frame();

stdfoot();

die;

?>

You are running way to many query's on that give this a shot

PHP Code:


		
			
 <?
require "backend/functions.php";
dbconn();

$res = mysql_query("SELECT * FROM lottery_config") or sqlerr(__FILE__, __LINE__);
while ($arr = mysql_fetch_assoc($res))
$arr_config[$arr['name']] = $arr['value'];
$endday = $arr_config['end_date'];
if (!$arr_config["enable"])show_error_msg("Sorry", "Lottery is disabled.");
stdhead();
begin_frame("Users who Have Purchased Tickets");
print("<center><font color=red>Lottery Ends: </font><b>" . $endday . "</b></center>");
?>
<table align=center border="1" width="600" cellpadding="5">
<tr>
<td class="tabletitle">#</td>
<td class="tabletitle">User name</td>
<td class="tabletitle">Number of tickets</td>
<td class="tabletitle">Uploaded</td>
<td class="tabletitle">Downloaded</td>
<td class="tabletitle">Ratio</td>
</tr>
<?
$sql = mysql_query("SELECT user FROM tickets") or die (mysql_error());
while ($myrow = mysql_fetch_assoc($sql))$user[] = $myrow["user"];
$user = array_values(array_unique($user));
for ($i = 0; $i < sizeof($user); $i++){$tickets[] = mysql_num_rows(mysql_query("SELECT * FROM tickets WHERE user=$user[$i]"));
$sqy = "SELECT username, uploaded, downloaded FROM users WHERE id=$user[$i]"
 $vay = mysql_query($sqy);
 $sq = mysql_fetch_row($vay);
$username[] = $sq['username'];
$id[] = $user[$i];
$uploaded[] = mksize($sq['uploaded']);
$downloaded[] = mksize($sq['downloaded']);
$ratio[] = $sq['downloaded'];
$ratio2[] = $sq['uploaded'];
echo "<tr><td class=tableb>" . ($i + 1) . "</td>
<td class=tableb><a href=account-details.php?id=$id[$i]>$username[$i]</a></td>
<td class=tableb>$tickets[$i]</td>
<td class=tableb>$uploaded[$i]</td>
<td class=tableb>$downloaded[$i]</td>
<td class=tableb>" . number_format($ratio2[$i] / $ratio[$i], 3) . "</td></tr>";
}
?>
</table>
<?
print("<center><h3><a href=games.php>Back to Casino</a></h3></center>");
end_frame();
stdfoot();
die;
?>

Parse error: syntax error, unexpected '$vay' (T_VARIABLE) in /home/www/viewtickets.php on line 29

Now the error has changed

sorry my fault

PHP Code:


		
			
 <?
require "backend/functions.php";
dbconn();

$res = mysql_query("SELECT * FROM lottery_config") or sqlerr(__FILE__, __LINE__);
while ($arr = mysql_fetch_assoc($res))
$arr_config[$arr['name']] = $arr['value'];
$endday = $arr_config['end_date'];
if (!$arr_config["enable"])show_error_msg("Sorry", "Lottery is disabled.");
stdhead();
begin_frame("Users who Have Purchased Tickets");
print("<center><font color=red>Lottery Ends: </font><b>" . $endday . "</b></center>");
?>
<table align=center border="1" width="600" cellpadding="5">
<tr>
<td class="tabletitle">#</td>
<td class="tabletitle">User name</td>
<td class="tabletitle">Number of tickets</td>
<td class="tabletitle">Uploaded</td>
<td class="tabletitle">Downloaded</td>
<td class="tabletitle">Ratio</td>
</tr>
<?
$sql = mysql_query("SELECT user FROM tickets") or die (mysql_error());
while ($myrow = mysql_fetch_assoc($sql))$user[] = $myrow["user"];
$user = array_values(array_unique($user));
for ($i = 0; $i < sizeof($user); $i++){$tickets[] = mysql_num_rows(mysql_query("SELECT * FROM tickets WHERE user=$user[$i]"));
$sqy = "SELECT username, uploaded, downloaded FROM users WHERE id=$user[$i]";
 $vay = mysql_query($sqy);
 $sq = mysql_fetch_row($vay);
$username[] = $sq['username'];
$id[] = $user[$i];
$uploaded[] = mksize($sq['uploaded']);
$downloaded[] = mksize($sq['downloaded']);
$ratio[] = $sq['downloaded'];
$ratio2[] = $sq['uploaded'];
echo "<tr><td class=tableb>" . ($i + 1) . "</td>
<td class=tableb><a href=account-details.php?id=$id[$i]>$username[$i]</a></td>
<td class=tableb>$tickets[$i]</td>
<td class=tableb>$uploaded[$i]</td>
<td class=tableb>$downloaded[$i]</td>
<td class=tableb>" . number_format($ratio2[$i] / $ratio[$i], 3) . "</td></tr>";
}
?>
</table>
<?
print("<center><h3><a href=games.php>Back to Casino</a></h3></center>");
end_frame();
stdfoot();
die;
?>

PHP Code:


		
			
 <?
require "backend/functions.php";
dbconn();

$res = mysql_query("SELECT * FROM lottery_config") or sqlerr(__FILE__, __LINE__);
while ($arr = mysql_fetch_assoc($res))
$arr_config[$arr['name']] = $arr['value'];
$endday = $arr_config['end_date'];
if (!$arr_config["enable"])show_error_msg("Sorry", "Lottery is disabled.");
stdhead();
begin_frame("Users who Have Purchased Tickets");
print("<center><font color=red>Lottery Ends: </font><b>" . $endday . "</b></center>");
?>
<table align=center border="1" width="600" cellpadding="5">
<tr>
<td class="tabletitle">#</td>
<td class="tabletitle">User name</td>
<td class="tabletitle">Number of tickets</td>
<td class="tabletitle">Uploaded</td>
<td class="tabletitle">Downloaded</td>
<td class="tabletitle">Ratio</td>
</tr>
<?
$sql = mysql_query("SELECT user FROM tickets") or die (mysql_error());
while ($myrow = mysql_fetch_assoc($sql))$user[] = $myrow["user"];
$user = array_values(array_unique($user));
for ($i = 0; $i < sizeof($user); $i++){
$tickets[] = mysql_num_rows(mysql_query("SELECT * FROM tickets WHERE user=$user[$i]"));
$sqy = "SELECT id, username, uploaded, downloaded, uploaded/downloaded as user_ratio FROM users WHERE id=$user[$i]";
 $vay = mysql_query($sqy) or die (mysql_error());
 $sq = mysql_fetch_row($vay);
$username[] = $sq['username'];
$id[] = $sq['id'];
$uploaded[] = mksize($sq['uploaded']);
$downloaded[] = mksize($sq['downloaded']);
$ratio[] = $sq['user_ratio'];
$ratio2[] = $sq['uploaded'];
echo "<tr><td class=tableb>" . ($i + 1) . "</td>
<td class=tableb><a href=account-details.php?id=$id[$i]>$username[$i]</a></td>
<td class=tableb>$tickets[$i]</td>
<td class=tableb>$uploaded[$i]</td>
<td class=tableb>$downloaded[$i]</td>
<td class=tableb>" . number_format($ratio[$i], 3) . "</td></tr>";
}
?>
</table>
<?
print("<center><h3><a href=games.php>Back to Casino</a></h3></center>");
end_frame();
stdfoot();
die;
?>

http://i.imgur.com/cOYt0Z6.png

the only problem it does not show the values only shows the quantity of tickets

PHP Code:


		
			
 <?
require "backend/functions.php";
dbconn();

$res = mysql_query("SELECT * FROM lottery_config") or sqlerr(__FILE__, __LINE__);
while ($arr = mysql_fetch_assoc($res))
$arr_config[$arr['name']] = $arr['value'];
$endday = $arr_config['end_date'];
if (!$arr_config["enable"])show_error_msg("Sorry", "Lottery is disabled.");
stdhead();
begin_frame("Users who Have Purchased Tickets");
print("<center><font color=red>Lottery Ends: </font><b>" . $endday . "</b></center>");
?>
<table align=center border="1" width="600" cellpadding="5">
<tr>
<td class="tabletitle">#</td>
<td class="tabletitle">User name</td>
<td class="tabletitle">Number of tickets</td>
<td class="tabletitle">Uploaded</td>
<td class="tabletitle">Downloaded</td>
<td class="tabletitle">Ratio</td>
</tr>
<?
$sql = mysql_query("SELECT user FROM tickets") or die (mysql_error());
while ($myrow = mysql_fetch_assoc($sql))$user[] = $myrow["user"];
$user = array_values(array_unique($user));
for ($i = 0; $i < sizeof($user); $i++){
$tickets[] = mysql_num_rows(mysql_query("SELECT * FROM tickets WHERE user=$user[$i]"));
$sqy = "SELECT id, username, uploaded, downloaded, uploaded/downloaded as user_ratio FROM users WHERE id=" . $user[$i];
 $vay = mysql_query($sqy) or die (mysql_error());
 $sq = mysql_fetch_assoc($vay);
echo "<tr><td class=tableb>" . ($i + 1) . "</td>
<td class=tableb><a href=account-details.php?id=" . $sq['id'] . ">" . $sq['username'] . "</a></td>
<td class=tableb>$tickets[$i]</td>
<td class=tableb>" . mksize($sq['uploaded']) . "</td>
<td class=tableb>" . mksize($sq['downloaded']) . "</td>
<td class=tableb>" . number_format($sq['user_ratio'], 3) . "</td></tr>";
}
?>
</table>
<?
print("<center><h3><a href=games.php>Back to Casino</a></h3></center>");
end_frame();
stdfoot();
die;
?>