?Duel Database Query?

[electricdonkey]

Hi there,
I'm working on a little project for a PHP-Nuke site. I'm building a Add-on module, well adapting one I've already made and copy righted.

What I'm try'n to add to it is a second query to find a rank image to go with a name in a "Top 10" block....
This is what I have so far... And works great : www.trsquad.com/index.php NOTE: The bottom right block!

Here's the script:

<?php

/************************************************************************/
/* PHP-NUKE: Web Portal System                                          */
/* ===========================                                          */
/*                                                                      */
/* Copyright (c) 2003 by Shadow~tr~ ([e-mail])         */
/* [url]http://www.trsquad.com[/url]                                                  */
/*                                                                      */
/* This is beta test of a Top 10 players block for the PHP-Nuke / Bab.stats*/
/* Chronos port.                                                                */
/*                                                                      */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License.       */
/************************************************************************/

if (eregi("block-Top-10-BHD.php", $_SERVER['PHP_SELF'])) {
    Header("Location: index.php");
    die();
}

global $prefix, $db, $sitename;
$sql = "SELECT name, id, rating FROM chronos_players ORDER BY rating DESC LIMIT 10";
$result = $db->sql_query($sql);
$content = "<br>";
while ($row = $db->sql_fetchrow($result)) {
    $rating = $row[rating];
    $name = "".htmlspecialchars(base64_decode($row[name]))."&nbsp;&nbsp;";
    $id = $row[id];
	//
	$content .= "<img src=\"images/arrow.gif\" border=\"0\" alt=\"\" title=\"\" width=\"9\" height=\"9\">&nbsp;<a href=\"modules.php?name=Chronos&amp;action=player_stats&amp;id=$id\">$name</a><br>";
    }
?>

Now I'm trying to add something like this:

<?php

/************************************************************************/
/* PHP-NUKE: Web Portal System                                          */
/* ===========================                                          */
/*                                                                      */
/* Copyright (c) 2003 by Shadow~tr~ ([e-mail])         */
/* [url]http://www.trsquad.com[/url]                                                  */
/*                                                                      */
/* This is beta test of a Top 10 players block for the PHP-Nuke / Bab.stats*/
/* Chronos port.                                                                */
/*                                                                      */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License.       */
/************************************************************************/

if (eregi("block-Top-10-BHD-1.php", $_SERVER['PHP_SELF'])) {
    Header("Location: index.php");
    die();
}

global $prefix, $db, $sitename;
$sql = "SELECT name, id, rating FROM chronos_players ORDER BY rating DESC LIMIT 10";
$result = $db->sql_query($sql);
$content = "<br>";
while ($row = $db->sql_fetchrow($result)) {
    $rating = $row[rating];
    $name = "".htmlspecialchars(base64_decode($row[name]))."&nbsp;&nbsp;";
    $id = $row[id];
	$sql2 = "SELECT thumbnail FROM chronos_ranks ORDER BY rating DESC LIMIT 10";
$result2 = $db->sql_query($sql2);
$content = "<br>";
while ($row2 = $db->sql_fetchrow($result2)) {
    $thumbnail = $row2[thumbnail];

$content .= "<img src=\"modules/Chronos/$thumbnail\" border=\"0\" alt=\"\" title=\"\" width=\"9\" height=\"9\">&nbsp;<a href=\"modules.php?name=Chronos&amp;action=player_stats&amp;id=$id\">$name</a><br>";
}
?>

What am I doing wrong here? After I add this section:

$sql2 = "SELECT thumbnail FROM chronos_ranks ORDER BY rating DESC LIMIT 10";
$result2 = $db->sql_query($sql2);
$content = "<br>";
while ($row2 = $db->sql_fetchrow($result2)) {
    $thumbnail = $row2[thumbnail];

$content .= "<img src=\"modules/Chronos/$thumbnail\" border=\"0\" alt=\"\" title=\"\" width=\"9\" height=\"9\">&nbsp;<a href=\"modules.php?name=Chronos&amp;action=player_stats&amp;id=$id\">$name</a><br>";
}PHP] I get a parse error, the error points to the line associated with the "?>" :confused:  Please help!

[Sphynx]

Looks like you didn't end your first WHILE. I'm thinking you need one more } at the end of the script, to enclose your second WHILE.

like so?

<?php

/ ************************************************************************/
/* PHP-NUKE: Web Portal System                                          */
/* ===========================                                          */
/*                                                                      */
/* Copyright (c) 2003 by Shadow~tr~ ([e-mail])         */
/* <a href="http://www.trsquad.com" target="_blank">[url]http://www.trsquad.com[/url]</a>                                                  */
/*                                                                      */
/* This is beta test of a Top 10 players block for the PHP-Nuke / Bab.stats*/
/* Chronos port.                                                                */
/*                                                                      */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License.       */
/ ************************************************************************/

if (eregi("block-Top-10-BHD-1.php", $_SERVER['PHP_SELF'])) {
    Header("Location: index.php");
    die();
}

global $prefix, $db, $sitename;
$sql = "SELECT name, id, rating FROM chronos_players ORDER BY rating DESC LIMIT 10";
$result = $db->sql_query($sql);
$content = "<br>";
while ($row = $db->sql_fetchrow($result)) {
    $rating = $row[rating];
    $name = "".htmlspecialchars(base64_decode($row[name]))."&nbsp;&nbsp;";
    $id = $row[id];
    $sql2 = "SELECT thumbnail FROM chronos_ranks ORDER BY rating DESC LIMIT 10";
$result2 = $db->sql_query($sql2);
$content = "<br>";
while ($row2 = $db->sql_fetchrow($result2)) {
    $thumbnail = $row2[thumbnail];

$content .= "<img src=\"modules/Chronos/$thumbnail\" border=\"0\" alt=\"\" title=\"\" width=\"9\" height=\"9\">&nbsp;<a href=\"modules.php?name=Chronos&action=player_stats&id=$id\">$name</a><br>";
}
}
?>

[electricdonkey]

That worked but it didn't do what I needed so someone suggested this...

<?php

if (eregi("block-Top-10-BHD-1.php", $_SERVER['PHP_SELF'])) {
    Header("Location: index.php");
    die();
}

global $prefix, $db, $sitename;
$sql = "SELECT name, id, rating FROM chronos_players ORDER BY rating DESC LIMIT 10";
$result = $db->sql_query($sql);
$content = "<br>";
while ($row = $db->sql_fetchrow($result)) {
    $rating = $row[rating];
    $name = "".htmlspecialchars(base64_decode($row[name]))."&nbsp;&nbsp;";
    $id = $row[id];
   $sql2 = "SELECT thumbnail FROM chronos_ranks WHERE rating<='$player_rating' ORDER BY rating DESC LIMIT 1";
$result2 = $db->sql_query($sql2);
$content = "<br>";
$row2 = $db->sql_fetch_array($result2);
$thumbnail = $row2[thumbnail];

$content .= "<img src='modules/Chronos/$thumbnail' border='0' alt='' title='' width='9' height='9'> <a href='modules.php?name=Chronos&action=player_stats&id=$id'>$name</a><br>";
}
?>

But it gives me this:
Fatal error: Call to undefined function: sql_fetch_array() in /usr/home/sites/www.trsquad.com/web/blocks/block-Top-10-BHD-1.php on line 34

Any thoughts? Man I really need to take a course in PHP😃 😕

[jerdo]

Is this post about duelling DB queries? Or dual queries?

[morrij]

Wouldnt it be best to use another while loop as you were before. PHP doesnt support the function you are calling, so use your new SQL2 query with the while loop...

....
global $prefix, $db, $sitename;
$sql = "SELECT name, id, rating FROM chronos_players ORDER BY rating DESC LIMIT 10";
$result = $db->sql_query($sql);
$content = "<br>";
while ($row = $db->sql_fetchrow($result)) {
    $rating = $row[rating];
    $name = "".htmlspecialchars(base64_decode($row[name]))."&nbsp;&nbsp;";
    $id = $row[id];
   $sql2 = "SELECT thumbnail FROM chronos_ranks WHERE rating<='$player_rating' ORDER BY rating DESC LIMIT 1";
$result2 = $db->sql_query($sql2);
$content = "<br>";
while ($row2 = $db->sql_fetchrow($result2)) {
    $thumbnail= $row2[thumbnail];
}
$content .= "<img src='modules/Chronos/$thumbnail' border='0' alt='' title='' width='9' height='9'> <a href='modules.php?name=Chronos&action=player_stats&id=$id'>$name</a><br>";
}

[electricdonkey]

Good thinkin, but I tried that...

It gives me results, but instead of listing 10 player names and the corisponding "rank" image it gives me the #10 player and the #1 image... (well the images is number 1 but it should be for the lowest player)

I'll check a few more things, maybe Ican get some more info. But thanks for the help everyone!:rolleyes:

[electricdonkey]

This works! 😃 But one of the guys I sent it too gets this error:

Fatal error: Call to a member function on a non-object in /home/sinister/public_html/blocks/block-Top-10-BHD-1-Final.php on line 25

Here's his site info. PHP-nuke 6.0 and mySQL version 3.23.56, PHP version 4.2.3

<?php

/************************************************************************/
/* PHP-NUKE: Web Portal System                                          */
/* ===========================                                          */
/*                                                                      */
/* Copyright (c) 2003 by Shadow~tr~ ([e-mail])         */
/* [url]http://www.trsquad.com[/url]                                                  */
/*                                                                      */
/* This is beta test of a Top 10 players block for the PHP-Nuke / Bab.stats*/
/* Chronos port.                                                                */
/*                                                                      */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License.       */
/************************************************************************/

if (eregi("block-Top-10-BHD.php", $_SERVER['PHP_SELF'])) {
    Header("Location: index.php");
    die();
}

global $prefix, $db, $dbi, $sitename;
$sql = "SELECT name, id, rating FROM chronos_players ORDER BY rating DESC LIMIT 10";
$result = $db->sql_query($sql);
$content = "<br>";
while ($row = $db->sql_fetchrow($result)) {
    $rating = $row[rating];
    $name = "".htmlspecialchars(base64_decode($row[name]))."&nbsp;&nbsp;";
    $id = $row[id];
    $sql2 = sql_query("SELECT name, thumbnail FROM chronos_ranks WHERE rating<='$rating' ORDER BY rating DESC LIMIT 0,1", $dbi);
    $result2 = sql_fetch_array($sql2, $dbi);
    $thumbnail = $result2[thumbnail];
    $rankname = $result2[name];

    $content .= "<img src='modules/Chronos/$thumbnail' border='0' alt='$rankname' title='$rankname'>&nbsp;<a href='modules.php?name=Chronos&amp;action=player_stats&amp;id=$id'>$name</a><br>";
}
?>

Anyone have any thoughts?😕