[SOLVED] Form Search

[longstand]

Could someone please show me how to attach a Php search engine script onto the form below, i have many search scripts examples, but i keep failing to tweak them onto my own search form.

I have only been using Php for about a month, and really i could do with someone fixing a working example of Php search code to the form below.

If anyone here decides to help me out on this, look below to find the database that i have created that the search script will get results from, and also the form that the user will use to enter there search.

Cheers,

My form:

HTML: Select all

<form name="form1" method="post" action="">
 <table width="254" border="0" cellspacing="0" cellpadding="0">
                        <tr>
                          <td width="103" height="27" class="style7"><div align="center" class="style2">Gender:</div></td>
                          <td width="151" class="style7"><label>
                            <select name="gender" class="style7" id="gender">
                              <option>Male</option>
                              <option>Female</option>
                            </select>
                          </label></td>
                        </tr>
                        <tr>
                          <td height="27" class="style7"><div align="center" class="style2">Age:</div></td>
                          <td class="style7"><label>
                            <select name="age" id="age">
                              <option>18</option>
                              <option>19</option>
                              
                            </select>
                          </label></td>
                        </tr>
                        <tr>
                          <td height="26" class="style7"><div align="center" class="style2">Height:</div></td>
                          <td class="style7"><label>
                            <select name="height" id="height">
                              <option>3</option>
                              <option>4</option>
                              <option>5</option>
                              <option>6</option>
                              <option>7</option>
                              <option>8</option>
                            </select>
                            <span class="style2">                            To</span>
                            <select name="height2" id="height2">
                              <option>1</option>
                              <option>2</option>
                              <option>3</option>
                              <option>4</option>
                              <option>5</option>
                              <option>6</option>
                              <option>7</option>
                              <option>8</option>
                              <option>9</option>
                              <option>10</option>
                              <option>11</option>
                            </select>
                          </label></td>
                        </tr>
                        <tr>
                          <td height="29" class="style7"><div align="center" class="style2">Hair Colour:</div></td>
                          <td class="style7"><label>
                            <select name="hair_colour" id="hair_colour">
                              <option>Black</option>
                              <option>Brown</option>
                              <option>Blonde</option>
                              <option>Red</option>
                              <option>Auburn</option>
                              <option>Other</option>
                            </select>
                          </label></td>
                        </tr>
                        <tr>
                          <td height="27" class="style7"><div align="center" class="style2">Area:</div></td>
                          <td class="style7"><label>
                            <select name="area" id="area">
                            <option>Any</option>
                          <option>England-Bath Avon</option>
                          <option>England-Bedforshire</option>
                          
                            </select>
                          </label></td>
                        </tr>
                        <tr>
                          <td height="32"><div align="center" class="style3">Work Interested:</div></td>
                          <td><label>
                            <select name="skills" id="skills">
                              <option>Look-A-Likes</option>
                              <option>Models &amp; Glamour</option>
                              <option>Actors &amp; TV Extras</option>
                              <option>Singers &amp; Vocalists</option>
                              <option>Theatre &amp; Musicals</option>
                              <option>Producers&amp;Aegents</option>
                            </select>
                            <input type="submit" name="search" value="Search" />
                            <br>
                          </label></td>
                        </tr>
  </table>
                      <p align="center">
                        <label></label>
                      </p>
                      <p align="left">&nbsp; </p>
</form>

My sql database:

CREATE DATABASE IF NOT EXISTS dbsignup;
USE dbsignup;
CREATE TABLE `customer` (`customer_id` INT( 3 ) NOT NULL
AUTO_INCREMENT,
`first_name` VARCHAR(30) NOT NULL ,
`last_name` VARCHAR(30) NOT NULL ,
`address` VARCHAR(70) NOT NULL ,
`city` VARCHAR(40) NOT NULL ,
`area` VARCHAR(50) NOT NULL ,
`email` VARCHAR(70) NOT NULL ,
`phone` VARCHAR(20) NOT NULL ,
`user_name` VARCHAR(30) NOT NULL ,
`password` VARCHAR(30) NOT NULL ,
`work_location` VARCHAR(60) NOT NULL ,
`agency_name` VARCHAR(70) NOT NULL ,
`agency_number` VARCHAR(30) NOT NULL ,
`skills` VARCHAR(500) NOT NULL ,
`about_me` VARCHAR(500) NOT NULL ,
`myspace_address` VARCHAR(50) NOT NULL ,
`hotmail_yahoo_address` VARCHAR(50) NOT NULL ,
`gender` VARCHAR(10) NOT NULL ,
`age` VARCHAR(3) NOT NULL ,
`height_one` VARCHAR(20) NOT NULL ,
`height_two` VARCHAR(20) NOT NULL ,
`build` VARCHAR(20) NOT NULL ,
`eye_colour` VARCHAR(20) NOT NULL ,
`hair_colour` VARCHAR(30) NOT NULL ,
`desired_work` VARCHAR(100) NOT NULL ,
`image_one` VARCHAR(10) NOT NULL ,
`image_two` VARCHAR(10) NOT NULL ,
`image_three` VARCHAR(10) NOT NULL ,
`image_four` VARCHAR(10) NOT NULL , UNIQUE ( `customer_id` ) );

[dab42pat]

I have a search on my site I can try and adapt. might take a while though.

[longstand]

Thanks m8t!

All be looking forward to the result

[alexgeek]

Umm didn't I help you with this yesterday?
[SOLVED] Search Script

[longstand]

Yer u sent me a script but i had trouble adapting it to me form, just not good enough with Php at the moment.

[alexgeek]

Read through the link I sent you.
Should explain everything.
Good luck mate.

[c010depunkk]

THREAD CLOSED (cleaning up)