[SOLVED] need help on drop down menu option

pixeltrace · February 28, 2007

guys, i need help on my drop down

i have two drop down wherein i want its value to change the variable in my query but i dont know how to do it.

so here i have

1. drop down menu for (name, id, date)

2. drop down menu for (ASC, DESC)

3. a go or submit button

my query is something like this

$test->sql = "SELECT * FROM job_ads WHERE ".$sort1." '.$sort2'";

and below is my codes for the drop down

<form>
sort by: 
<select name="firstoption">
<option value="1">name</option>
<option value="2">ID</option>
<option value="3">date</option>
</select>
<select name="secondoption">
  <option value="1">ASC</option>
  <option value="2">DESC</option>
</select>
<input type="submit" name="Submit" value="Go" />
</form>

what i wanted to happen is

on the first drop down, its will change the value of sort1

on the second drop down it will change the value of sort2

then when the go or submit button is selected

changes will be down.

how to this is i dont have any ideas yet.

hope you guys could help me with this.

thanks in advance!

nloding · February 28, 2007

<form method="get" action="sort.php">
sort by: 
<select name="sort1">
<option value="name">name</option>
<option value="id">ID</option>
<option value="date">date</option>
</select>
<select name="sort2">
  <option value="ASC">ASC</option>
  <option value="DESC">DESC</option>
</select>
<input type="submit" name="Submit" value="Go" />
</form>

<?php

$query = "SELECT * FROM job_ads ORDER BY" . $_GET['sort1'] . $_GET['sort2'];

?>

If you want to keep the numeric values of the options, you can run a switch statement to make it either ASC or DESC or name. And make sure "name", "id", etc. are columns in your table.

I'm assuming the sort options are on the same page as the results display ... in which case, I'd recommend using GET, and make the form action itself.

pixeltrace · February 28, 2007

yes, the result will also fall on the same page.

i'll try this one.

thanks!

pixeltrace · February 28, 2007

hi,

i am getting an error.

may i ask,,

how do i add a default value since my query is on top of the form

so when the page first loads, it will read the query first before the form.

how do i add a default value on sort1 and sort2 so when the page loads

this will be the value that the program will execute.

i know that code line should be placed on top of the query but

i dont have any idea what the code is and how.

hope you could help me with this.

thanks!

pixeltrace · February 28, 2007

need help on this please.

this is the error message that i am getting now.

Parse error: parse error, unexpected T_VARIABLE in c:\hosting\webhost4life\member\diorgrace\admean\job\view1.php on line 12

and this is the entire code of my page

<?php
session_start();

if (session_is_registered("username")){

include($_SERVER['DOCUMENT_ROOT']."/admean/pagina/my_pagina_class.php");

$test = new JHpage;
$sort1 = "name";
$sort2 = "ASC";

$test->sql = "SELECT * FROM job_ads ORDER BY ".$_GET['sort1']." "$_GET['sort2']"";
// the (basic) sql statement (use the SQL whatever you like)
$result = $test->get_page_result(); // result set
$num_rows = $test->get_page_num_rows(); // number of records in result set 
$nav_links = $test->navigation(" | ", "currentStyle"); // the navigation links (define a CSS class selector for the current link)
$nav_info = $test->page_info(); // information about the number of records on page ("to" is the text between the number)
$simple_nav_links = $test->back_forward_link(true); // the navigation with only the back and forward links, use true to use images
$total_recs = $test->get_total_rows(); // the total number of records
?>
<script type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>

<table width="100" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><img src="../images/spacer.gif" width="6" height="10"></td>
    <td><table width="216" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td colspan="3" valign="top" bgcolor="#3261BB"><img src="images/spacer.gif" width="1" height="1"></td>
      </tr>
      <tr>
        <td align="left" bgcolor="#3261BB" width="1"><img src="images/spacer.gif" width="1" height="1"></td>
        <td width="214" valign="top">
	<table width="1049" border="0" cellspacing="2" cellpadding="0">
            <tr>
              <td colspan="13"><table width="616" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td width="329" class="text6">
				<?php
				 echo "   total record found: " .$total_recs; ?></td>
                    <td width="287"> </td>
                  </tr>
              </table></td>
            </tr>
            <tr>
              <td colspan="13"><form method="get" action="jobmngr.php?id=2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td width="783"> </td>
                    <td width="262" class="text6">sort by :
<select name="sort1">
<option value="name">name</option>
<option value="id">ID</option>
<option value="date">date</option>
</select>
<select name="sort2">
  <option value="ASC">ASC</option>
  <option value="DESC">DESC</option>
</select>
<input type="submit" name="Submit" value="Go" />
</td>
                  </tr>
              </table></form></td>
            </tr>
            		<form action="jobrepost.php" method="post">
<tr>
              	<td colspan="13"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td width="60%" align="left" class="text8">| <a href="repost" class="link2">repost</a> | <a href="open" class="link2">open</a> | <a href="close" class="link2">close</a> | </td>
                  <td width="39%" align="right"><!-- nav top -->
                      <?
				echo "<span class='link1'>".$nav_links."</span>";
				?>                  </td>
                  <td width="1%" align="right"><img src="images/spacer.gif" width="12" height="10" /></td>
                </tr>
              </table></td>
            </tr>
            <tr>
              <td width="29" align="center" bgcolor="#83C2ED" class="text5"> </td>
              <td width="51" align="center" bgcolor="#83C2ED" class="text5">ID</td>
              <td width="230" align="center" valign="top" bgcolor="#83C2ED" class="text5">title</td>
              <td width="140" align="center" bgcolor="#83C2ED" class="text5">level </td>
              <td width="254" align="center" bgcolor="#83C2ED" class="text5">client</td>
              <td width="25" align="center" bgcolor="#83C2ED" class="text5">N</td>
              <td width="25" align="center" bgcolor="#83C2ED" class="text5">C</td>
              <td width="25" align="center" bgcolor="#83C2ED" class="text5">S</td>
              <td width="25" align="center" bgcolor="#83C2ED" class="text5">I</td>
              <td width="24" align="center" bgcolor="#83C2ED" class="text5">B</td>
              <td width="28" align="center" bgcolor="#83C2ED" class="text5">CV</td>
              <td width="60" align="center" bgcolor="#83C2ED" class="text5">status</td>
              <td width="105" bgcolor="#83C2ED"> </td>
            </tr>
<?php 
for ($i = 0; $i < $num_rows; $i++) {
$jobid = mysql_result($result, $i, "jobid");
$j_position = mysql_result($result, $i, "j_position");
$level = mysql_result($result, $i, "level");
$c_name = mysql_result($result, $i, "c_name");
$cperson = mysql_result($result, $i, "cperson");
$nconsidered = mysql_result($result, $i, "nconsidered");
$considered = mysql_result($result, $i, "considered");
$scheduled = mysql_result($result, $i, "scheduled");
$interviewed = mysql_result($result, $i, "interviewed");
$blocked = mysql_result($result, $i, "blocked");
$cv = mysql_result($result, $i, "cv");
$j_status = mysql_result($result, $i, "j_status");

?>            <tr>
              <td bgcolor="#FFFFCC" class="text8"><span class="text5">
                <input type="checkbox" name="checkbox[]" value="<? echo"jobid"; ?>" />
              </span></td>
              <td bgcolor="#FFFFCC" class="text8">J<? echo ($jobid <= 9) ? $jobid : $jobid;?>				  </td>
              <td bgcolor="#FFFFCC"> <a href="javascript:;" target="_blank" class="link1" onclick="MM_openBrWindow('job/jobpost.php?jobid=<? echo "$jobid"; ?>','','width=720')">
		<? echo "$j_position";?></a></td>
              <td bgcolor="#FFFFCC" class="text8"> 
             <? echo "$level";?>
		 </td>
              <td bgcolor="#FFFFCC" class="text8"> 
             <? echo "$c_name";?><br> 
		 <i><? echo "$cperson";?></i></td>
              <td bgcolor="#FFFFCC" class="text8">
		  <? echo "$nconsidered";?></td>
              <td bgcolor="#FFFFCC" class="text8">
		  <? echo "$considered";?></td>
              <td bgcolor="#FFFFCC" class="text8">
		  <? echo "$scheduled";?></td>
              <td bgcolor="#FFFFCC" class="text8">
		  <? echo "$interviewed";?></td>
              <td bgcolor="#FFFFCC" class="text8">
		  <? echo "$blocked";?></td>
              <td bgcolor="#FFFFCC" class="text8">
		  <? echo "$cv";?></td>
              <td bgcolor="#FFFFCC" class="text8"> 
              <? echo "$j_status";?></td>
              <? echo "<td align='center' bgcolor='#FFFFCC'><a href='jobmngr.php?id=3&jobid=$jobid' class='link1'>edit</a> | <a href='jobmngr.php?id=4&jobid=$jobid' class='link1'>applications</a> </td></tr>";
            ?>
     <?        
}
?>
            <tr>
              <td colspan="13" bgcolor="#83C2ED"><img src="../images/spacer.gif" width="10" height="2" /></td>
            </tr>
            <tr>
              <td colspan="13"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td width="60%" align="left" class="text8"> </td>
                  <td width="39%" align="right"><!-- nav top -->
                      <?
				echo "<span class='link1'>".$nav_links."</span>";
				?>
                  </td>
                  <td width="1%" align="right"><img src="images/spacer.gif" width="12" height="10" /></td>
                </tr>
              </table></td>
            </tr>		</form>

            <tr>
              <td colspan="13"> </td>
            </tr>
        </table>
	</td>
        <td align="right" bgcolor="#3261BB" width="1"><img src="images/spacer.gif" width="1" height="1"></td>
      </tr>
      <tr>
        <td colspan="3" valign="top" bgcolor="#3261BB"><img src="images/spacer.gif" width="1" height="1"></td>
      </tr>
    </table></td>
    <td><img src="../images/spacer.gif" width="6" height="10"></td>
  </tr>
</table>
<? 
}else{
echo "<font face=\"Arial\">You are not authorized to access this page ... Please <a href='../index.php'>Login</a></font>";
}
?>

hope you could help me with this.

i am not sure if the assigning of my

sort1 and sort2 variable is correct and my query too.

need help

thanks!

itsmeArry · February 28, 2007

instead of using this

$sort1 = "name";

$sort2 = "ASC";

$test->sql = "SELECT * FROM job_ads ORDER BY ".$_GET['sort1']." "$_GET['sort2']"";

use it like this

if(isset($_GET['sort1']) && $_GET['sort1']!='')

$sort1 = $_GET['sort1'];

else

$sort1 = "name";

if(isset($_GET['sort2']) && $_GET['sort2']!='')

$sort2 = $_GET['sort2'];

else

$sort2 = "ASC";

$test->sql = "SELECT * FROM job_ads ORDER BY ".$sort1." ".$sort2;

nloding · February 28, 2007

You're getting the T_VARIABLE error when you run the script the first time through, because the $_GET variables don't exist. If you didn't know, GET puts the variables in the URL ... so your URL already contains "?id=2" ... $_GET['id'] would equal 2 ...

Since sort1 and sort2 aren't in the URL, the $_GET variables fail the first time through.

You need to run the IF statements posted above. If the $_GET variables exist, then the sort variables are set to their values. If not, they are set to a default value. Then use $sort1 and $sort2 instead of $_GET in your query.

I should have said that the first time, sorry.

pixeltrace · February 28, 2007

hi,

is the query correct?

$test->sql = "SELECT * FROM job_ads ORDER BY ".$sort1." ".$sort2;

or is it missing some "" or ' ?

need help because i am getting errors from this line

thanks!

itsmeArry · February 28, 2007

$test->sql = "SELECT * FROM job_ads ORDER BY " . $sort1 . " ". $sort2 . "";

itsmeArry · February 28, 2007

if you still get the error then do this

$test->sql = "SELECT * FROM job_ads ORDER BY $sort1 $sort2";

it will work....

pixeltrace · February 28, 2007

i used this and this is the error message that i am getting

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\hosting\webhost4life\member\diorgrace\admean\pagina\my_pagina_class.php on line 90

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\hosting\webhost4life\member\diorgrace\admean\pagina\my_pagina_class.php on line 63