944,087 Members | Top Members by Rank

Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 4658
  • MySQL RSS
Dec 1st, 2005
0

Mysql Search results

Expand Post »
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
Attached Files
File Type: zip search.zip (9.9 KB, 23 views)
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
bennieblanco is offline Offline
7 posts
since Dec 2005
Dec 1st, 2005
0

Re: Mysql Search results

Step 1 - Return all the fields for the product:
Change this query:
MySQL Syntax (Toggle Plain Text)
  1. "SELECT product_id, product_description FROM product WHERE product_id = '" . $product . "'"
to
MySQL Syntax (Toggle Plain Text)
  1. "SELECT * FROM product WHERE product_id = '" . $product . "'"

Step 2 - Return partial match queries:
Update the query:
MySQL Syntax (Toggle Plain Text)
  1. "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?
Reputation Points: 38
Solved Threads: 25
Posting Shark
chrisbliss18 is offline Offline
902 posts
since Aug 2005
Dec 1st, 2005
0

Re: Mysql Search results

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?
Reputation Points: 10
Solved Threads: 0
Newbie Poster
bennieblanco is offline Offline
7 posts
since Dec 2005
Dec 1st, 2005
0

Re: Mysql Search results

Works Like A Charm!!! Awesome
Reputation Points: 10
Solved Threads: 0
Newbie Poster
bennieblanco is offline Offline
7 posts
since Dec 2005
Dec 1st, 2005
0

Re: Mysql Search results

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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
bennieblanco is offline Offline
7 posts
since Dec 2005
Dec 1st, 2005
0

Re: Mysql Search results

Can you be more specific?

What is case sensitive?
Where are you putting a space? Show me the code and the output.
Reputation Points: 38
Solved Threads: 25
Posting Shark
chrisbliss18 is offline Offline
902 posts
since Aug 2005
Dec 1st, 2005
0

Re: Mysql Search results

Quote originally posted by chrisbliss18 ...
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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
bennieblanco is offline Offline
7 posts
since Dec 2005
Dec 1st, 2005
0

Re: Mysql Search results

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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
bennieblanco is offline Offline
7 posts
since Dec 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: Ideal System
Next Thread in MySQL Forum Timeline: How to hyperlink mysql search results?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC