[RESOLVED] Problem sorting with a URL

lauramayer

Afternoon,

I can't seem to make this work. I have the following query that gets its variables from a form:

$query = "SELECT S.SID,S.LastName,S.FirstName,A.Application_Date,A.Application_Score,A.One_Pref,A.Two_Pref,A.Three_Pref,A.Four_Pref,
A.Five_Pref,AC.GPA,AC.Year_Of_Grad
FROM AllStudent_Test.Student S, Res_Life_Dev.AcademicTbl AC, Res_Life_Dev.ApplicationTbl A, Res_Life_Dev.PersonTbl P 
WHERE S.SID = AC.CampusID
AND S.SID = A.CampusID 
AND S.SID = P.CampusID
AND A.Position_Requested Like '%$Position%' 
AND A.Application_Score = '$Score'
AND A.One_Pref = '$Area' 
ORDER BY $order";

And the url sorting works fine...as long as I only have 2 variables Position and Score when I add One_Pref=$Area it dumps the value for area every time. However it keeps position and score.

I used this for the URL sort .

echo "<a href=\"{$_SERVER['PHP_SELF']}?Position_Requested=$Position&amp;One_Pref=$Area&amp;Application_Score=$Score&amp;order=$heading\">$heading</a>";

I echoed out Position, Area and score. Every time I submit the form the first time its fine and shows the values submitted BUT when I click on the URL to sort the results the Area echoed changes from the value submitted to '' Position and score remain the same. HOWEVER the url retains the value for area that was submitted.

I'm stumped. Any thoughts would be great.

Thanks

Laura

bogu

After u click on that url how do u know the values submited from your form?

Two thing in my mind to do that:
1. use javascript to submit a form that have as action the url u want and hidden field with the value of the submited form
2. use a session where u keep the values from the form u submited so u know how to make the selection (this is the one I suggest u)

For more about this, use the search function of this forum, there are other threads open with this problem on the pagination (search +pagination), when going on another page how do u know what was your search filter?

lauramayer

I echoed out the position, area and score :

$Position = $_REQUEST['Position_Requested'];
$Score = $_REQUEST['Application_Score'];
(line 56) $Area = $_REQUEST['Area'];

echo "Position: " . $Position;
echo "<br>";
echo "Score: " . $Score;
echo "<br>";
echo "Area: " . $Area;
echo "<br>";

When I submit the form I get for example:

Position: RA
Score: 4
Area: Central

when I added

error_reporting (E_ALL);

to the top I get this when I click on the heading link:

Notice: Undefined index: Area in /usr/local/apache/htdocs-dev-secure/Res_Life/SearchScoreResults.php on line 56

Position: RA
Score: 4
Area

Does that help? Or just make it more muddy?

Thanks for the feedback.

Laura

lauramayer

I fixed it sort of I worked around it 🙂

I used this http://kryogenix.org/code/browser/sorttable/ and it worked perfectly.

Thanks again.

Laura

bogu

I have a smiple question for u, how will u use that library if u have pagination?

lauramayer

Oh okay. I'm not using pagination though.