Mysql Search results

[bennieblanco]

Hi there ,I am working on my web site and
I need some help with my search result query's
If you look here

http://www.sensitivetechnology.com/search.php
and in the top search field enter 74AC86SC the resilt will show Product ID and Description ,but it won't show quantity and price
And also I need a query that once you have enterd first 2 leters or numbers of the part it will list all parts containing the first 2 numbers/letters
I am stuck in the midlle and I also want to make hyperlink the results to my request page
http://www.sensitivetechnology.com/rfq.php
so once u click on the result it would add the same one to the
"Your rfq" field in the rfq.php page

I atached the needed files and my querys are in the search.class file

Thank you

[chrisbliss18]

Step 1 - Return all the fields for the product:
Change this query:

"SELECT product_id, product_description FROM product WHERE product_id = '" . $product . "'"

to

"SELECT * FROM product WHERE product_id = '" . $product . "'"

Step 2 - Return partial match queries:
Update the query:

"SELECT * FROM product WHERE product_id LIKE '" . $product . "%'"

This query returns all products that match or begin with the search text.

Step 3 - Add RFQs to the rfq.php page:
Are you wanting to be able to add multiple RFQs or just fill in one single RFQ? In other words, do you intend for the person to be able to click on multiple links and have all of the selected products show up in the text area or just to give them the ability to click a link and have that single product show up in the text area?

[bennieblanco]

just to give them the ability to click a link and have that single product show up
I updated the search.zip it contains the rfq.php file also

THANK YOU FOR FAST REPLY!
why is it not showing other 2 fields?

[bennieblanco]

Works Like A Charm!!! Awesome

[bennieblanco]

hmm it is case sensitive for some reason? it must be small letters and if you add space after the part# it wont show anything

[chrisbliss18]

Can you be more specific?

What is case sensitive?
Where are you putting a space? Show me the code and the output.

[bennieblanco]

Can you be more specific?

What is case sensitive?
Where are you putting a space? Show me the code and the output.

OK ,when I put the part # in search field example
XC2V6000-4BF957C it is not going to find it since the part is in caps
if I enter : xc2v6000-4bf957c it is going to find it
if I enter space after part# it is not going to find it
if I take the dash away from part# it is not going to find it

[bennieblanco]

And regarding the hyperlink you can see what I need here

http://vital-ic.com/index.php?page=part&
just enter xc2v in part search field