http://coh.trap17.net/dkp/
so on the trap17 phpmyadmin query sql function the make_db.sql that i have wasnt working right. i had to break it apart and add everything using phpmyadmin. the result was success.
so, i decided to buy webspace from computinghost.com so i could get our guilds website up, the same make_db.sql errored out at "default charset = latin1" i took all of those entries out of the script and tried again, and it worked. i assigned all the values and set everything up like it should, but now the dkp site looks like this..
http://crucibleofheroes.com/dkp/index.php
so, i jumped into the .php files to try and find out why the player and item functions on the site werent working right.
i have very limited knowledge of php and need some help on this one.
this first portion of code is from the raid section of the site.
CODE
$result = mysql_query("SELECT S.name, COUNT(*), (COUNT(*)/(SELECT COUNT(*) FROM Bids))*100 FROM Bids B, Sets S WHERE B.item LIKE S.pattern AND S.tier = $tier GROUP BY S.name;", $db);
if (!$result) { echo " <p class=\"error\">Couldn't get set drop counts: " . mysql_error() . "</p>\n"; require 'footer.php'; exit; }
$isOdd = 1;
while ($row = mysql_fetch_row($result)) {
if ($isOdd) echo " <tr class=\"table-odd\">";
else echo " <tr class=\"table-even\">";
echo " <td class=\"table-primary\">$row[0]</td>
<td class=\"table-numeric\">$row[1]</td>
<td class=\"table-numeric\">$row[2]%</td>
</tr>\n";
$isOdd = !$isOdd;
if (!$result) { echo " <p class=\"error\">Couldn't get set drop counts: " . mysql_error() . "</p>\n"; require 'footer.php'; exit; }
$isOdd = 1;
while ($row = mysql_fetch_row($result)) {
if ($isOdd) echo " <tr class=\"table-odd\">";
else echo " <tr class=\"table-even\">";
echo " <td class=\"table-primary\">$row[0]</td>
<td class=\"table-numeric\">$row[1]</td>
<td class=\"table-numeric\">$row[2]%</td>
</tr>\n";
$isOdd = !$isOdd;
i'm pretty sure the error is in this code somewhere.
please help! thanks in advance..
-Thomas
***edit***
that portion of script is from the index-items.php that i have
CODE
$result = mysql_query("SELECT S.name, COUNT(*), (COUNT(*)/(SELECT COUNT(*) FROM Bids))*100 FROM Bids B, Sets S WHERE B.item LIKE S.pattern AND S.tier = $tier GROUP BY S.name;", $db);
if (!$result) { echo " <p class=\"error\">Couldn't get set drop counts: " . mysql_error() . "</p>\n"; require 'footer.php'; exit; }
$isOdd = 1;
while ($row = mysql_fetch_row($result)) {
if ($isOdd) echo " <tr class=\"table-odd\">";
else echo " <tr class=\"table-even\">";
echo " <td class=\"table-primary\">$row[0]</td>
<td class=\"table-numeric\">$row[1]</td>
<td class=\"table-numeric\">$row[2]%</td>
</tr>\n";
$isOdd = !$isOdd;
if (!$result) { echo " <p class=\"error\">Couldn't get set drop counts: " . mysql_error() . "</p>\n"; require 'footer.php'; exit; }
$isOdd = 1;
while ($row = mysql_fetch_row($result)) {
if ($isOdd) echo " <tr class=\"table-odd\">";
else echo " <tr class=\"table-even\">";
echo " <td class=\"table-primary\">$row[0]</td>
<td class=\"table-numeric\">$row[1]</td>
<td class=\"table-numeric\">$row[2]%</td>
</tr>\n";
$isOdd = !$isOdd;
thanks..
