View Single Post
Old 05-10-2009, 05:58 PM   #3 (permalink)
oldskool
oldskool's Avatar
 
Electrical Systems Design

Join Date: Jun 2008

Location: Maine, USA

Posts: 1,647

oldskool has a spectacular aura aboutoldskool has a spectacular aura about

Default Re: HELP - php mysql db search from form input

In the case of :

Code:
select * from car_inventory where make = 'ford' and model = 'focus' and year = 2002
does a multi-part query like that need parentheses, office ? I was studying a tutorial and I thought it said you did. Maybe it was a different use of SQL other than MySQL, I don't remember.

Would it be like ....

Code:
select * from car_inventory where (make = 'ford' and model = 'focus' and year = 2002)
EDIT: I answered my own question. Nope, I was wrong. I was thinking of a combined query like the one found here

To the OP, this site is a good one for SQL basics. I like it anyway >> SQL Syntax

Last edited by oldskool; 05-10-2009 at 06:07 PM.
oldskool is offline