testing specific array value in if conditional

iamchris

I wish to suppress empty fields in the resulting array of a query against multiple address type tables. I'm getting:

Able, Ned
,
,

410.123.4577

Jones, Ed
123 4th Ave, Suite 1
Anytown, NY 12345
UNITED STATES OF AMERICA
212.111.9999

Smith, Vern
13 Rouge Ave
Toronto, ON M8U7X1
CANADA
604.949.9134

What I'd like is this:

Able, Ned
410.123.4577

Jones, Ed
123 4th Ave, Suite 1
Anytown, NY 12345
212.111.9999

Smith, Vern
13 Rouge Ave
Toronto, ON M8U7X1
CANADA
604.949.9134

Notice in the above that Ned Able has no address, so his address rows are suppressed, and Ed Jones has no country as the United States has been suppressed, whereas Vern Smith lives in Canada and his country is displayed.

I thought I'd use the logic of if address is not null then printf([address] and if country is not 'USA' then printf([country]) but I keep getting parse errors when I insert the if conditional.

Code is below. Where might I use some if logic, and what is the syntax, to suppress data? I attempted to put the if in the body of the while loop in order to check the values on each iteration, but again, I got a parse error.

Help?

$db = mysql_connect("localhost", "USERNAME", "pwd");
mysql_select_db("DATABASE",$db);
$result = mysql_query("SELECT A.LAST_NAME, A.FIRST_NAME, A.MID_NAME, B.ADDRESS_1, B.ADDRESS_2, B.ADDRESS_3, B.CITY, B.STATE, B.POSTAL, B.COUNTRY, C.PHONE, D.EMAIL, E.PL_YEAR, E.PL_SEM
FROM NAMES_TBL A
LEFT JOIN ADDRESS_TBL B ON (A.DBID = B.DBID AND B.EFF_DT <= CURRENT_DATE AND B.PREFERRED = 'Y')
LEFT JOIN PHONE_TBL C ON (A.DBID = C.DBID AND C.EFF_DT <= CURRENT_DATE AND C.PREFERRED = 'Y')
LEFT JOIN EMAIL_TBL D ON (A.DBID = D.DBID AND D.EFF_DT <= CURRENT_DATE AND D.PREFERRED = 'Y')
LEFT JOIN PLEDGED_TBL E ON A.DBID = E.DBID
WHERE A.EFF_DT <= CURRENT_DATE
ORDER BY A.LAST_NAME,A.FIRST_NAME",$db);

while ($row = mysql_fetch_array ($result)) {
printf("%s,&nbsp",$row["LAST_NAME"]);
printf("%s&nbsp", $row["FIRST_NAME"]);
printf("%s ", $row["MID_NAME"]);
printf("%s&nbsp", $row["ADDRESS_1"]);
printf("%s&nbsp", $row["ADDRESS_2"]);
printf("%s \n", $row["ADDRESS_3"]);
printf("%s,&nbsp", $row["CITY"]);
printf("%s&nbsp", $row["STATE"]);
printf("%s \n",$row["POSTAL"]);
printf("%s \n",$row["COUNTRY"]);
printf("%s",$row["PHONE"]);
printf(" \n%s",$row["EMAIL"]);
printf(" \nPledged:&nbsp%s", $row["PL_SEM"]);
printf("&nbsp%s", $row["PL_YEAR"]);
}

daphreeek

Thats easy. Just add an if statement b4 each line to see if there is any value in each variable.

This will only print the last name if it exists:

  if ($row["LAST_NAME"] != "")
    printf("<p><b>%s, ",$row["LAST_NAME"]);

Just do a similar if for each variable.

Hope that helps.
- Matt