Sorry for creating a new thread but I'm trying to target the exact source of the problem I am having and each time, a new question comes up that I need to ask.
I have 2 sites: MMOCraze.com and RPGMax.com.
The error is occurring on RPGMax.com.
The error occurs on the page http://www.rpgmax.com/mmo/gamedirectory/gameprofile
MMOCraze has the same page but slightly different URL structure: http://www.mmocraze.com/game-directory/game-profile.
The game directory pages on both sites use the same template files with different databases. The information and structure in both databases are the same. On the game directory page for both sites, a loop is created to output a list of games stored in the database table. Each game in the list has a link that directs the user to the game's profile page.
The code to create that link is as follows:
That's the code used on RPGMax. MMOCraze uses the exact same code with slight difference:
<a href=http://www.rpgmax.com/mmo/gamedirectory/gameprofile/?gameId=" . $row['gameId'] . ">" . $row['gameName'] . "</a>
Both sites use the same _GET code and sql in their game profile pages:
<a href=http://www.mmocraze.com/game-directory/game-profile/?gameId=" . $row['gameId'] . ">" . $row['gameName'] . "</a>
$gameId = $_GET['gameId'];
(MMOCraze uses wp_MMOCraze_games)
$result = mysql_query("SELECT * FROM wp_rpgmax_games WHERE gameId=$gameId");
The sql usage in the html code...excerpt:
$row = mysql_fetch_array($result);
MMOCraze works but not RPGMax. When you click on http://www.mmocraze.com/game-directo...le/?gameId=XXX, it will take you to the game profile page with the gameId query attached. RPGMax isn't doing that. It fails to fetch the gameId query and goes straight to the game profile page with no data outputted.
<h1>Official Site: <a href=" . $row['gameUrl'] . " target=_new>" . $row['gameName'] . "</a></h1>
<img src=" . $row['gameLogoUrl'] . " alt='Game Logo' border='0' height=105></td>
Any ideas? That's the main problem...MMOCraze works but NOT RPGMax. MMOcraze returns an array but not RPGMax, which is weird because they use the same htaccess and same sql/php code.