Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by JPATX2
-
SELECT statement help
Thank you for both of your responses. Both worked and solved the issue, your help is much appreciated. Thanks again! -JP -
SELECT statement help
I have the following query. SELECT * FROM projects WHERE assembly_type = '2' OR assembly_type = '6' OR assembly_type = '10' OR assembly_type = '14' OR assembly_type = '18' OR assembly_type = '22' OR assembly_type = '26' OR assembly_type = '30' AND status != 'Complete' ORDER BY pnum ASC It... -
MySQL Query - Left join syntax
Hi Everyone, I've been starring at this for an hour and a half....does anyone see a problem with this query? Thanks! $query_projects = "SELECT * FROM projects WHERE engineer = '$engineer' AND customer = '$customer' AND platform = '$platform' AND dtype = '$dtype' AND archived = '$archived'...
