"+msql_result($result,$row,"Text_for_ad")+". ";
if(msql_result($result,$row,"I_name"));
$msg=$msg+msql_result($result,$row,"First_name")+" ";
$msg=$msg+msql_result($result,$row,"Last_name")+". ";
else;
$msg=$msg+"";
endif;
if(msql_result($result,$row,"I_address"));
$msg=$msg+msql_result($result,$row,"Address_1")+" ";
$msg=$msg+msql_result($result,$row,"Address_2")+" ";
$msg=$msg+msql_result($result,$row,"City")+", ";
$msg=$msg+msql_result($result,$row,"State")+" ";
$msg=$msg+msql_result($result,$row,"Zip")+". ";
else;
$msg=$msg+"";
endif;
if(msql_result($result,$row,"I_e_mail_1") &&
msql_result($result,$row,"E_mail_1"));
$msg=$msg+""+msql_result($result,$row,"E_mail_1")+". ";
else;
$msg=$msg+"";
endif;
if(msql_result($result,$row,"I_telephone_1") &&
msql_result($result,$row,"Telephone_1"));
$msg=$msg+msql_result($result,$row,"Telephone_1")+". ";
else;
$msg=$msg+"";
endif;
if(msql_result($result,$row,"I_fax") &&
msql_result($result,$row,"Fax"));
$msg=$msg+msql_result($result,$row,"Fax")+". ";
else;
$msg=$msg+"";
endif;
if(msql_result($result,$row,"I_web") &&
msql_result($result,$row,"Personal_web"));
$msg=$msg+""+msql_result($result,$row,"Personal_web")+". ";
else;
$msg=$msg+"";
endif;
$Date=date("m/d/y",msql_result($result,$row,"Expire_Date"));
$msg=$msg+$Date+". ";
$msg=$msg+"Ad ID# " + msql_result($result,$row,"Ad_ID") + " ";
$msg=$msg+msql_result($result,$row,"State")+".";
$msg=$msg+"\n";
endif;
$row++;
endwhile;
$msg=$msg+"