Anyone have a working search form script?

Iam looking for a working PHP search form script to use as reference for my design. I am looking to have a search form take in variables, when submitted it will connect to MySQL database and display all results in a paged fashion(prefferably with an image as well) and hyperlinking to a detailed description of the chosen recoed. I'm pulling my hair out here trying to construct this and thought if someone has gotten something similar up and running before if you would be willing to share you knowledge please.

Why don't you use googles' custom search engine for your site?

It's not a search engine I am after, it's a search on a database based on information taken from a form.

Oh ... sorry ... my bad.

So ... there's more than 1 input? Hmmm ... interesting.

Yeah, just the same as a search engine would work except it would have a SELECT * from table WHERE (and list all conditions). I can perform the search and display the results it really the displaying of a results page thats giving me bother

How do you mean? Can you show up some code and a link so we can try it out?

Can't at the moment unfortunatley, at work and the code is on home machine. To give you an idea of my search form and displaying of results linked to detail page, it's going to be a sports products version of www.colvinhouston.com site.

Sounds to me like you need some sort of pagination so you basically create a list of so many records and then create next and previous links depending on the number of records.

I have a script I use to do this if you need it

Ihave a pagination functionworking already with just codes but cant get the result page to display as required with an Image at one side and details next to it.

What you could do is either a div class with an image floated to the left and a hyperlink with a description of the result so when you list the results, they all look the same or you could use a table.

I haven't done it but i don't hink it will be too hard

If you need any help, i'll have a look

Can you sho me what you have got....it's the bit after the mysql_fetch_array that I'm after

A strange question AdRock, would you be willing to take on freelance work for the weekend? I really need an exact type of search,result and dispaly function similar the site specified for Mon but on full weekend shifts so won't have a chance. Let me know please.

I'll give it a go.

PM see more info and I'll get on it