Member Avatar for 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

search.zip (9.9 KB)
  • 2 Contributors
  • 7 Replies
  • 126 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by bennieblanco
Member Avatar for 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?

Member Avatar for 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?

Member Avatar for bennieblanco

Works Like A Charm!!! Awesome

Member Avatar for 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

Member Avatar for chrisbliss18

Can you be more specific?

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

Member Avatar for 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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.