IF Statement in SQL Query

[andy98]

Hi
I know this is possible in Coldfusion but can this be done in PHP.

I have a search form with these fields:
Order_Number
Cust_Firstname
Cust_Surname

This form submits to a page with a query where I would like to be able to test for the existence of these fields within the SQL query - so that I can dislay the results based upon what fields have values.

Can anyone help?

 

[MrBelfry]

Try something like this at the end of your query

WHERE Order_Number !='' OR Cust_Firstname !="" OR Cust_Surname !=""

But this will (if it works - I'm a little rusty) not return fields if any of those fields are empty.

MrBelfry

http://www.mrbelfry.co.uk

http://www.lighthousecc.co.uk

http://www.imagemagazine.co.uk

 

[andy98]

That just returns everything!

Any other ideas?

 

[Olavxxx]

hmm..
you only want to look for the fields, not the field values?

if you use OR, it will return true, if any of them are true.

If you use AND, all has to return true

WHERE 1 > 2 OR 2 < 3; <- true, even if 1 > 2 == false

WHERE 1 > 2 AND 2 < 3; <- false, since both are not true

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster

 

[andy98]

It's OK I have resolved this by eliminating one of the fields and using an IF Statement outside of the query to select a specific query to run.

Many Thanks!

http://www.goplanetgo.co.uk