January 19th, 2004, 02:27 AM
|
|
Contributing User
|
|
Join Date: Jun 2003
Posts: 72
Time spent in forums: 11 m 36 sec
Reputation Power: 6
|
|
|
unknown problem
my code is
PHP Code:
<?
include ('conf/db.php');
if ($_GET['type']==""){
echo "Please choose a map type";
}
else
{
mysql_connect($csv_mysqlhost,$csv_mysqluser,$csv_m ysqlpass);
@mysql_select_db($csv_mysqldb) or die( "Unable to select database");
$gettype_query="select * from $csv_maptypestable WHERE maptypeid='".$_GET['type']."'";
$gettype_result=mysql_query($gettype_query);
$gettype_numrows=mysql_numrows($gettype_result);
if ($gettype_numrows==0){
echo "Map type doesn't exist!";
}
else
{
if ($sort!="" && $sort!=alph && $sort!=date){
echo "No such sort order.";
}
else
{
//abc order maptype start
if ($sort=="" || $sort=="alph"){
$getmaps_query="select * from $csv_mapstable WHERE maptype='".$_GET['type']."' && accepted='1'";
$getmaps_result=mysql_query($getmaps_query);
$getmaps_num=mysql_numrows($getmaps_result);
if ($getmaps_num==0){
echo "There are no maps for this maptype";
}
else
{
$m=0;
$abc=array();
while ($m<$getmaps_num) {
$abc[$m]=mysql_result($getmaps_result,$m,"mapname");
$m++;
}
sort($abc);
for($z=0;$z < count($abc);$z++) {
$map_query="select * from $csv_mapstable WHERE mapname='".$abc[$z]."' && accepted='1'";
$map_result=mysql_query($map_query);
$mapid=mysql_result($map_result,$z,"mapid");
$mapviews=mysql_result($map_result,$z,"views");
$mapdls=mysql_result($map_result,$z,"downloads");
//begin map rating
$query1 = "select * from $csv_mapsratingtable WHERE mapid='" . $mapid . "' && vote='a'";
$result1=mysql_query($query1);
$resultscountA = mysql_num_rows($result1);
$gradeA=4;
$calculated_gradeA=$resultscountA*$gradeA;
$query2 = "select * from $csv_mapsratingtable WHERE mapid='" . $mapid . "' && vote='b'";
$result2=mysql_query($query2);
$resultscountB = mysql_num_rows($result2);
$gradeB=3;
$calculated_gradeB=$resultscountB*$gradeB;
$query3 = "select * from $csv_mapsratingtable WHERE mapid='" . $mapid . "' && vote='c'";
$result3=mysql_query($query3);
$resultscountC = mysql_num_rows($result3);
$gradeA=2;
$calculated_gradeC=$resultscountC*$gradeC;
$query4 = "select * from $csv_mapsratingtable WHERE mapid='" . $mapid . "' && vote='d'";
$result4=mysql_query($query4);
$resultscountD = mysql_num_rows($result4);
$gradeA=1;
$calculated_gradeD=$resultscountD*$gradeD;
$query5 = "select * from $csv_mapsratingtable WHERE mapid='" . $mapid . "' && vote='f'";
$result5=mysql_query($query5);
$resultscountF = mysql_num_rows($result5);
$gradeA=0;
$calculated_gradeF=$resultscountF*$gradeF;
$totalcount = $resultscountA + $resultscountB + $resultscountC + $resultscountD + $resultscountF;
$totalpoints=$calculated_gradeA+$calculated_gradeB +$calculated_gradeC+$calculated_gradeD+$calculated _gradeF;
if ($totalcount!=0){
$average_grade=$totalpoints/$totalcount;
$average_grade2=round($average_grade);
if ($average_grade2==4){
$maprating="A";
}
if ($average_grade2==3){
$maprating="B";
}
if ($average_grade2==2){
$maprating="C";
}
if ($average_grade2==1){
$maprating="D";
}
if ($average_grade2==0){
$maprating="F";
}
}
else
{
$maprating="Not Rated";
}
//end map rating
$len = strlen($abc[$z]) - 4;
$map_no_ext = substr($abc[$z],0,$len);
echo "".$map_no_ext."<br>";
echo "".$mapviews." views<br>";
echo "".$mapdls." downloads<Br>";
echo "Rating: ".$maprating."<br>";
echo "<Br><br>";
}
}
}
//abc order maptype end
//date order maptype start
if ($sort=="date"){
$getmaps_query="select * from $csv_mapstable WHERE maptype='".$_GET['type']."' && accepted='1' ORDER by mapid DESC";
$getmaps_result=mysql_query($getmaps_query);
$getmaps_num=mysql_numrows($getmaps_result);
if ($getmaps_num==0){
echo "There are no maps for this maptype";
}
else
{
$m=0;
while ($m<$getmaps_num) {
$mapname=mysql_result($getmaps_result,$m,"mapname");
$mapid=mysql_result($getmaps_result,$m,"mapid");
$mapviews=mysql_result($getmaps_result,$m,"views");
$mapdls=mysql_result($getmaps_result,$m,"downloads");
//begin map rating
$query1 = "select * from $csv_mapsratingtable WHERE mapid='" . $mapid . "' && vote='a'";
$result1=mysql_query($query1);
$resultscountA = mysql_num_rows($result1);
$gradeA=4;
$calculated_gradeA=$resultscountA*$gradeA;
$query2 = "select * from $csv_mapsratingtable WHERE mapid='" . $mapid . "' && vote='b'";
$result2=mysql_query($query2);
$resultscountB = mysql_num_rows($result2);
$gradeB=3;
$calculated_gradeB=$resultscountB*$gradeB;
$query3 = "select * from $csv_mapsratingtable WHERE mapid='" . $mapid . "' && vote='c'";
$result3=mysql_query($query3);
$resultscountC = mysql_num_rows($result3);
$gradeA=2;
$calculated_gradeC=$resultscountC*$gradeC;
$query4 = "select * from $csv_mapsratingtable WHERE mapid='" . $mapid . "' && vote='d'";
$result4=mysql_query($query4);
$resultscountD = mysql_num_rows($result4);
$gradeA=1;
$calculated_gradeD=$resultscountD*$gradeD;
$query5 = "select * from $csv_mapsratingtable WHERE mapid='" . $mapid . "' && vote='f'";
$result5=mysql_query($query5);
$resultscountF = mysql_num_rows($result5);
$gradeA=0;
$calculated_gradeF=$resultscountF*$gradeF;
$totalcount = $resultscountA + $resultscountB + $resultscountC + $resultscountD + $resultscountF;
$totalpoints=$calculated_gradeA+$calculated_gradeB +$calculated_gradeC+$calculated_gradeD+$calculated _gradeF;
if ($totalcount!=0){
$average_grade=$totalpoints/$totalcount;
$average_grade2=round($average_grade);
if ($average_grade2==4){
$maprating="A";
}
if ($average_grade2==3){
$maprating="B";
}
if ($average_grade2==2){
$maprating="C";
}
if ($average_grade2==1){
$maprating="D";
}
if ($average_grade2==0){
$maprating="F";
}
}
else
{
$maprating="Not Rated";
}
$len = strlen($mapname) - 4;
$map_no_ext = substr($mapname,0,$len);
echo "".$map_no_ext."<br>";
echo "".$mapviews." views<br>";
echo "".$mapdls." downloads<Br>";
echo "Rating: ".$maprating."<br>";
echo "<Br><br>";
//end map rating
$m++;
}
}
}
//date order maptype end
}
}
}
?>
i keep getting a problem at the part:
for($z=0;$z < count($abc);$z++) {
$map_query="select * from $csv_mapstable WHERE mapname='".$abc[$z]."' && accepted='1'";
$map_result=mysql_query($map_query);
$mapid=mysql_result($map_result,$z,"mapid"); <----problem
$mapviews=mysql_result($map_result,$z,"views"); <----problem
$mapdls=mysql_result($map_result,$z,"downloads"); <----problem
it say Unable to jump to row 1 on MySQL result index 12
|
Dev Articles Community Forums Sponsor:
. i found the problem,
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
