query($sql); $count = mysqli_num_rows($result); if($count == 0){ $passwordCheck = false; } } //attempts to insert subscriber into subscribe table $sql = "INSERT INTO subscribe (biz_title, brand, comp_name, sal, first_name, last_name, address, address_2, city, state, zip, country,". "mail_to, alt, area_code, phone, area_code_fax, fax, email, month, subscribe, status, am_id, opt_inla, opt_inlc, opt_intle, opt_ineb, pass,". "edited) VALUES ". "('$biz_title', '$brand', '$comp_name', '$sal', '$first_name', '$last_name', '$address', '$address_2', '$city' , '$state', '$zip', '$country', ". "'$mail_to', '$alt_mail', '$area_code', '$phone', '$area_code_fax', '$fax', '$email','$month', ". "'$subscribe', '$status', '$am_id', '$opt_inla', '$opt_inlc', '$opt_intle', '$opt_ineb', '$pass', NULL)"; if(mysqli_query($conn, $sql)){ echo ""; } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($conn); } //attempts to update ylist on subscriber from above $sql = "UPDATE subscribe SET ylist_id = '" . $ylist_id . "', needs = '" . $needs . "' WHERE first_name='" . $first_name . "' AND last_name='" . $last_name . "' AND email='" . $email . "'"; if(mysqli_query($conn, $sql)){ echo ""; } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } //sends password to user $to = $email; $subject = ' Re: LADetails Account'; $msg = $first_name . ", you have successfully completed the New Subscription Request Application. \n" . "Here is your password for LandscapeArchitect.com: \n" . "Password: " . $pass . "\n". " \n" . "We encourage you to browse the Product Information Request page and request \n" . "any product information you need from our vendors. In order to provide you \n" . "with timely service, all product information requests are processed weekly. \n" . " \n" . "Thank you for visiting LandscapeArchitect.com. \n" . " \n" . "The largest landscape oriented database on the web!" ; mail ($to, $subject, $msg, 'From:' . $email); $DISPLAY = []; ?>

Create Your Account

CLOSE X

Step 1 Step 2 Step 3

Please take the time to complete this section as accurately as possible. The information is used to ensure you receive the magazine(s), news and promotions you want to receive and not the ones you don't want. Thank you!

Contact Information

First Name*

Last Name*

Company Name*

EMAIL*

CONFIRM EMAIL*

PHONE NUMBER*

Title* Job Title query($sql); while($row = mysqli_fetch_array($result)){ $newName = str_replace('_', ' ', $row['name']); echo '' . $newName . ''; } ?> Other

I Am A* I am a... query($sql2); $georgeSelectsIds = [4,7,10,34,37,16,19,2,28,23,26,32,35,6,9,30,33,36,19]; while($row = mysqli_fetch_array($result2)){ if(in_array($row['idAccount'], $georgeSelectsIds)){ if (!stristr($row['name'],"---")) { $newName = str_replace('_', ' ', $row['name']); echo '' . $newName . ''; } } } ?>

I would like to subscribe / opt-in to receive:

• LASN Magazine Subscription
• LA Weekly
• LASN Digital Magazine
• Targeted Vendor Promotions
• LASN Calls for Editorial

NEXT: REQUEST PRODUCT INFORMATION

Request Product Information

CLOSE X

Step 1 Step 2 Step 3

Select ProductsTo receive special offers and/or information about specific products, jump to the categories and select the products below. To skip this section or when you are Finished Picking Products, scroll to the bottom of the page and select the 'Submit' button.

Landscape Lighting Outdoor Living Business Services Pavers, Masonry, Blocks & Rocks Park and Recreation Water Features Site Amenities Tools & Equipment Plant Materials Green Roof Installation Equipment Plant Accessories Water Management / Irrigation Maintenance Equipment Turf & Ornamental Stormwater/Erosion Control Parts & Repair

query($sql); $numOfRows = mysqli_num_rows($result); echo '

'; echo '

' . $catName . '

'; echo ''; echo '

'; while($row = mysqli_fetch_array($result)) { $id = $row['sub_number']; echo '

' . $row['name'] . '

'; } echo '

Top Finished Picking Products

'; } ?>

No thanks, I don't want to select any products

NEXT: ENTER YOUR MAILING ADDRESS

Subscribe to the Magazine

CLOSE X

Step 1 Step 2 Step 3

Enter Your Mailing Address LASN is happy to send your magazine to your Home or Office.

ADDRESS LINE 1*

ADDRESS LINE 2

CITY*

State* 2) {?> State >Alabama >Alaska >Alberta >Arizona >Arkansas >British Columbia >California >Colorado >Connecticut >Delaware >District of Columbia >Florida >Georgia >Hawaii >Idaho >Illinois >Indiana >Iowa >Kansas >Kentucky >Louisiana >Maine >Manitoba >Maryland >Massachusetts >Michigan >Minnesota >Mississippi >Missouri >Montana >Nebraska >Nevada >New Brunswick >Newfoundland >New Hampshire >New Jersey >New Mexico >New York >North Carolina >North Dakota >Northwest Territories >Nova Scotia >Ohio >Oklahoma >Ontario >Oregon >Pennsylvania >Quebec >Rhode Island >Saskatchewan >South Carolina >South Dakota >Tennessee >Texas >Utah >Vermont >Virginia >Washington >West Virginia >Wisconsin >Wyoming >Yukon

ZIP CODE*

SUBMIT ADDRESS