Codezwiz >> Forums >> General PHP Nuke Help >> Is it possible to....

Sorry about the completely unhelpful title.

To have an HTTP IF statement where i a different SQL statement is declared. So i have static-games.l2p.net/reviews=pc This would then query the database and only return results which are PC games, then i have /reviews=xbox then it would only return X-Box ones. Sorry if it's a little vague but i'm interested to see if it's possible.

Thanks
Splinter.

I don't see why you would need an IF statement. You would do it all in your query statement, something like "select all from reviews where category=pcgames and subcategory=xbox order by id ascending".

i want it on an If statement because that way i wouldn't have to have a seperate "master" page for each different platform. So in the IF statement it could be like...

<?php if (isset($HTTP_GET_VARS["PC""])) { ?>
<?php
mysql_select_db($database_conn, $conn);
$query_rsReviews = "SELECT * FROM tblgames WHERE gamePlatform = 'PC' AND gameLetter = 'A' ORDER BY gameTitle ASC ";
$rsReviews = mysql_query($query_rsReviews, $conn) or die(mysql_error());
$row_rsReviews = mysql_fetch_assoc($rsReviews);
$totalRows_rsReviews = mysql_num_rows($rsReviews);
<?php } ?>