MYSql errors i dont understand why!

[miles_rich]

if i use this query

SELECT uid, cust_type, name_title, name_first, name_last, adr_line_1, adr_line_2, adr_line_3, adr_line_4, adr_post, tel_one_area, tel_one, tel_two_area, tel_two, tel_mobile_area, tel_mobile, tel_fax_area, tel_fax, inf_enabled FROM tbl_customer WHERE tel_fax_area OR tel_fax = 'private' ORDER BY uid desc

I get three lines brought back, the two fields are number fields, that hold telephone numbers, so why does this happen??

[benbox]

I think it may be because you need to do:
WHERE tel_fax_area = 'private' OR tel_fax = 'private'
instead of:
WHERE tel_fax_area OR tel_fax = 'private'

Also, why don't you do: SELECT FROM..... if you have so many fields being called..
(where means all)

so it would be

SELECT * FROM tbl_customer WHERE tel_fax_area = 'private' OR tel_fax = 'private' ORDER BY uid desc

[miles_rich]

The reason i dont use " * " is because i dont want to select all the fields, because then it would be pulling out fields i did not want to use.

Thankyou for your help though.