asked on

Search function not working

The search function on the following page isn't working properly: http://www.ssuexed.com/search.php?year=2017&sem=0&ge=C3%2C+*ETH&id=0&cName=&cDept=&tLastName=

For example, if you select the option for GE Type as "C3, *ETH", you will obtain an output that includes "GE C3" as well.

I am attaching the code files - I am thinking that the problem must be in one of these files, i.e., search_subcats.php file, but I am not certain.

I would appreciate any help.
search.php
search_cache.php
search_subcats.php

Julian Hansen

Where is the function showSearchTable defined (line 218 of search.php)

$catalog->showSearchTable($ge, $cName, $cDept, $tLastName);

Open in new window

Guy Hengel [angelIII / a3]

also, where is _cleanVar() function defined? does it include urldecode function

geeta_m9

ASKER

I don't know. I am sending you the rest of the files that I have.
course.php
programs.php
catalog.php
_catalog_defines.php
test.php

Julian Hansen

Nope does not appear to be in any of those.

geeta_m9

ASKER

Ok, I managed to find some more php files which were in an "includes" folder
_catalog_defines-1.php
_stdfunctions.php

Julian Hansen

Not there either.

geeta_m9

ASKER

Hi Julian,

Could it be in here, perhaps?

Geeta
catalog_container.php
catalog_container-1.php
course_container.php
department_container.php
msg_container.php
program_container.php
section_container.php
defines.php

geeta_m9

ASKER

I believe the function you are looking for is in catalog_container-1.php

ASKER CERTIFIED SOLUTION

Julian Hansen

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

geeta_m9

ASKER

Hi Julian,

I do not have a test server to add the code to the catalog_container-1 program file and run it. If I insert it into the program and upload it, it will be live.

I can, however, run SQL queries against the database and obtain the output. So, if you could give it to me in that format, that would be great.

Julian Hansen

I don't have anything to give you - I want to see what queries the code produces.

geeta_m9

ASKER

Sorry, I forgot to close this question. The problem has been resolved.

Thank you for your help.

Geeta

Julian Hansen

You are welcome.