advanced search recordset HELP

[Jonathan_Fortis]

I have tried following the tutorial here http://help.adobe.com/en_US/dreamweaver/cs/using/WScbb6b82af5544594822510a94ae8d65-78aaa.html

the simple one works fine but i try and follow the advanced and it doesnt show how to make the correct SQL statement using cs5 in php

i am trying to search 3 different criteria from 3 text feilds and display either all or one of the seatch results.

the search page form is

<form id="Jobtitle" name="Jobtitle" method="get" action="../job-description.php">

          <p>

            <input name="JobTitle" type="text" class="textfeilds" value="Job Title" size="32" />

            <label for="Location"></label>

            <input name="Location" type="text" value="Location" size="32" />

            <label for="Salary"></label>

            <input name="Salary" type="text" class="textfeilds" value="Salary" size="32" />

          </p>

          <p align="right">

            <input type="image" src="../images/jobsearch-button.png" width="120" height="17" border="0" value="Submit" alt="submit" usemap="#Map" />

            <map name="Map" id="Map">

              <area shape="rect" coords="1,0,67,16" href="#" />

            </map>

          </p>

      </form>

the results page is

SELECT think_jobsearch.tk_job_title, think_jobsearch.tk_job_location, think_jobsearch.tk_job_salary

FROM think_jobsearch

then i dont know where to go from there? with regards to varialble

can anyone help?

[Jonathan_Fortis]

Well if i do changed the tables do i need to change the SQL aswell??

got any pointers?

what would you advise using. between either changing the database or adding SQL?

[Jonathan_Fortis]

Would it be best to use the database full text searching or add an sqk statement?

[Jonathan_Fortis]

i have looked at my database options for FULLTEXT in the TYPE but it doesnt have it?

i am using

phpMyAdmin - 2.11.9.5

[bregent]

phpMyAdmin - 2.11.9.5

I'm not sure. I know that you need at least version 3.23.23 of MySQL, but I'm not sure if the version of phpMyAdmin is related to the MySQL version. I would say that the version you have is probably too old.

[Jonathan_Fortis]

i have version

MySQL client version: 4.1.25

what would you recommend use the database full text searching or add an sqk statement?

[bregent]

>what would you recommend use the database full text searching

I don't use MySQL and am not too familiar with its full text search capabities. Because and index you add can adversely affect performance, you need to do a full analysis of your needs and get a more complete understanding of how it works.

>or add an sqk statement?

You can't simply add a SQL statement to accomplish what you want. You need to build a search function using a combination of PHP and SQL. To do that, you must first have a very good working knowledge of both PHP scripting and SQL SELECT statements.

[Jonathan_Fortis]

yes i understand you need to combine both. Ok well i will have a look out there to see if anyone else can point me in the right direction

there are a few web pages out there i have found so will try and go through them

thanks