• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Php question + mysql

Kavvson

Gdy boli cie glowa wez
Joined
Jun 25, 2008
Messages
1,177
Reaction score
72
Location
Poland
PHP:
$result = mysql_query("SELECT * FROM items");


$pattern = mysql_real_escape_string($GLOBALS['input']);
$sort = mysql_real_escape_string(isset($GLOBALS['sort']) ? $GLOBALS['sort'] : 'id');

$searchResultQuery = "SELECT * FROM items ORDER BY $sort";
?>
<form name="myform">
<select name="sort" id="sort" style="float: left;" onChange="javascript:document.myform.submit();">
    <option value="name">Name</option>
    <option value="price">Price</option>
</select>
</form>
<?PHP
if($login->isLoggedIn()) {
  echo "Members Area | Hello ".$_SESSION['username']." | <a href='logout.php'>Logout</a>";
 
  echo "<br><br>";
  echo "<a href='?do=list'>Item List</a> | Manage Items | Add Item";
  echo "<br>";             
  echo "<br>";
  
 	if($_REQUEST['do'] == 'index')
	{ 
            echo "<br><br>";
            echo "content for index";
        }
        
  	if($_REQUEST['do'] == 'list')
	{

This is a working sort code but if i hit the option it redirects me @ admin.php?sort=price and I want admin.php?do=list&sort=price but really don't know how to do it I think its kinda easy but my brain is afk:eek:

Im sure this javascript:document.myform.submit() is what has to be changed;s

- - - Updated - - -

bump
 
Back
Top