Help with Select ?

[Mike-2003]

I have the following code in a select statement and wanted to see if there is an easier way to type it instead of it going across the page as it does. I guess I would like to see how to make it look like neater code?

Thanks,
Mike

 //SQL query
	$custid = "164044";
	$custid2 = "168384";
	$custid3 = "169834";
	$custid4 = "220460";
    $Query = "SELECT FPCUSMAS.CNUMBR, FPCUSMAS.CLNAME, FPCUSMAS.CZIP from FPCUSMAS where FPCUSMAS.CNUMBR = $custid or FPCUSMAS.CNUMBR = $custid2 or FPCUSMAS.CNUMBR = $custid3 or FPCUSMAS.CNUMBR = $custid4";

[kevinsequeira]

$Query = "SELECT FPCUSMAS.CNUMBR, FPCUSMAS.CLNAME, FPCUSMAS.CZIP from FPCUSMAS";
$Query .=" where FPCUSMAS.CNUMBR = $custid";
$Query .=" or FPCUSMAS.CNUMBR = $custid2";
$Query .=" or FPCUSMAS.CNUMBR = $custid3";
$Query .=" or FPCUSMAS.CNUMBR = $custid4";

reg
kevin

[Mike-2003]

Thanks! 😃

[Thora_Fan]

I just break mine across with the return key.

$Query = "SELECT FPCUSMAS.CNUMBR, FPCUSMAS.CLNAME, FPCUSMAS.CZIP 
from FPCUSMAS
where FPCUSMAS.CNUMBR = $custid 
or FPCUSMAS.CNUMBR = $custid2
or FPCUSMAS.CNUMBR = $custid3 
or FPCUSMAS.CNUMBR = $custid4";