Jump to content

Recommended Posts

guys,

 

i need help,

 

how do i set my action on my form to go here

http://www.jobhirings.com/new/admean/resumemngr.php?id=3&sort1=appid&specialization=Electrical+Engineer&sort2=ASC&Submit=Go

 

in my current code its going here

http://www.jobhirings.com/new/admean/resumemngr.php?sort1=appid&specialization=Electrical+Engineer&sort2=ASC&Submit=Go

without the id=3

 

this is my current code

 

<?php
session_start();

if (session_is_registered("username")){

include("pagina/my_pagina_class.php");

if(isset($_GET['sort1']) && $_GET['sort1']!='')
     $sort1 = $_GET['sort1'];
else
     $sort1 = "appid";

if(isset($_GET['specialization']) && $_GET['specialization']!='')
     $sort3 = $_GET['specialization'];
else
     $sort3 = "";

if(isset($_GET['sort2']) && $_GET['sort2']!='')
     $sort2 = $_GET['sort2'];
else
     $sort2 = "ASC";

$test = new JHpage;
$test->sql = "SELECT * FROM applicant WHERE specialization LIKE '%". $sort3 ."%' ORDER BY ".$sort1 ." ".$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="954" border="0" cellspacing="2" cellpadding="0">
            <tr>
              <td colspan="6"><form method="get" action="resumemngr.php?id=3"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td width="566"><span class="text6">
                      <?php
				 echo "   total record found: " .$total_recs; ?>
                    </span></td>
                    <td width="479" align="right" class="text6">sort by :
<select name="sort1">
<option value="appid">ID</option>
<option value="fname">name</option>
<option value="dateregistered">date registered</option>
</select> 
<select name="specialization">
  <?
$uSql = "SELECT specialization FROM specialization ORDER by sid ASC";
$uResult = mysql_query($uSql, $connection);
if(!$uResult){
echo 'no data found';
}
else{
while($uRow = mysql_fetch_row($uResult)){
?>
  <option value="<?= $uRow[0]?>">
  <?= $uRow[0]?>
  </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="6"><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>
            <tr>
              <td width="68" align="center" bgcolor="#83C2ED" class="text5">ID</td>
              <td width="320" align="center" valign="top" bgcolor="#83C2ED" class="text5">name</td>
              <td width="262" align="center" bgcolor="#83C2ED" class="text5">email</td>
              <td width="156" align="center" bgcolor="#83C2ED" class="text5">level</td>
              <td width="136" align="center" bgcolor="#83C2ED" class="text5">date registered </td>
            </tr>
<?php 
for ($i = 0; $i < $num_rows; $i++) {
$appid = mysql_result($result, $i, "appid");
$fname = mysql_result($result, $i, "fname");
$lname = mysql_result($result, $i, "lname");
$email = mysql_result($result, $i, "email");
$specialization = mysql_result($result, $i, "specialization");
$level = mysql_result($result, $i, "level");
$dateregistered = mysql_result($result, $i, "dateregistered");
?>            <tr>
              <td bgcolor="#FFFFCC" class="text8"><span class="text5">
              </span> A<? echo ($appid <= 9) ? $appid : $appid;?>				  </td>
              <td bgcolor="#FFFFCC"> <a href="javascript:;" class="link1" onClick="MM_openBrWindow('../jobsearch/jobpost.php?jobid=<? echo "$jobid"; ?>','','scrollbars=yes,width=720,height=700')">
		<? echo " ".$fname." ".$lname." "; ?></a></td>
              <td bgcolor="#FFFFCC" class="text8"> 
             <? echo "$email";?>			 </td>
              <td bgcolor="#FFFFCC" class="text8"> <? echo "$level";?><br></td>
              <td bgcolor="#FFFFCC" class="text8"><? echo "$dateregistered";?></td>
              <? echo "</td></tr>";
            ?>
     <?        
}
?>
            <tr>
              <td colspan="6" bgcolor="#83C2ED"><img src="../images/spacer.gif" width="10" height="2" /></td>
            </tr>
            <tr>
              <td colspan="6"><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="6"> </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

thanks!

 

 

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.