$order = "ASC";
if (isset($_GET["ORDER"]))
{
$value = $_GET["ORDER"]; if (($value == "ASC") || ($value == "DESC"))
{
$order = $value;
}
else if ($value == "RAND")
{
$order = "RAND()";
}
}$SPORDER = $order;
I.A. Gray wrote:
*********************************************** This Email Has Been Virus Swept ***********************************************
Hi everyone,
I know this is probably really simple, but I am not very good at expressions and conditional statements. I am wanting to show a list from a MYSQL database. I am using the URL to store the variables that control the output. The variable $ORDER can be set to ASC (Ascending), DESC (Descending and RAND (Random). What I want the script to do is set $SPORDER to this value. If $_GET['ORDER'] is not set then it gets the default value (ASC), if this is any other than ASC, DESC or RAND (ie. someone has messed with the variables in the URL) then it also gets the default (ASC). Finally if $_GET['ORDER'] is set to RAND then I want $SPORDER to equal RAND() so that I can use the value in the SQL query.
Here is part of the script:
<?php
if (!isset($_GET['ORDER'])) { // Checks if the 'ORDER' variable from the URL is set. If it is NOT set the following happens... $SPORDER = "ASC"; // The variable $SPORDER is given the value ASC, since ASC (Ascending Order) is the default value. } else { // The following happens if the 'ORDER' variable IS set... $SPORDER = $_GET['ORDER']; // The variable $SPORDER is given the value of the variable 'ORDER' taken from the URL. if ( (($SPORDER !== "ASC") && ($SPORDER !== "DESC")) && ($SPORDER !== "RAND")) { // If the variable $SPORDER does NOT have the value of either "ASC" (Ascending), "DESC" (Descending) or "RAND" (Random) then the following happens... $SPORDER == "ASC"; // The variable $SPORDER is given the default value "ASC" } else { // If the variable $SPORDER DOES have the value of either "ASC", "DESC" or "RAND" then the following happens... if ($SPORDER == "RAND") { // If $SPORDER has the following of "RAND" (Random Order) then... $SPORDER == "RAND()"; // $SPORDER is given the value "RAND()" which is the correct value for submission to the MYSQL query. } }
} // End of the Conditional Statements regarding the ORDER variable.
?>
I think the problem part could be: if ( (($SPORDER !== "ASC") && ($SPORDER !== "DESC")) && ($SPORDER !== "RAND"))
I am trying to say if $SPORDER does not equal "ASC", "DESC" or "RAND" then do the following. There maybe other problems in my code as well that are not making this work. I would be grateful if you could shed some light on it!
Best wishes, Ian Gray
-- ---------------------- www.curvedvision.com ----------------------
This communication is confidential to the intended recipient(s). If you are not that person you are not permitted to make use of the information and you are requested to notify the sender immediately of its receipt then destroy the copy in your possession. Any views or opinions expressed are those of the originator and may not represent those of Advanced System Architectures Ltd.
*** This Email Has Been Virus Checked ***
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
