Subscribe to our e-Newsletter

Thank you for subscribing. You will receive a confirmation email to activate your subscription.

\n" . "X-Priority: 3\n" . "X-MSMail-Priority: Normal\n" . "X-Mailer: PHP"; mail($to,$subject,$body,$headers); echo "

Your request has been sent

"; } if ($_POST['sub_conf2'] == "Yes" && $_POST['validate'] == "3239aBBa3") { //need to subscribe them to ECN $sql = "select * from ecn_id_index where id_code = 'SI' limit 1"; $result = mysql_query($sql) or die(mysql_error()); $sequence = mysql_fetch_assoc($result); //now, store the existing number $user_index = $sequence['id_value']; $next_index = $user_index + 1; //now, update the index record $sql = "update ecn_id_index set id_value = '$next_index' where id_code = 'SI' limit 1"; $result = mysql_query($sql) or die(mysql_error()); //ok, now that that's done, need to record the user record. extract($_POST); $random_num = rand(100000000,1000000000); $sql = "insert into ecn_subscribers (`sub_id`, `sub_firstname`, `sub_lastname`, `sub_company`, `sub_city`, `sub_prov`, `sub_country`, `sub_conf`, `sub_type`, `sub_email`, `sub_verify_email`, `sub_password`, `sub_pw_plain`, `nl_version`, `sub_status`, `sub_created`, `sub_modified`, `sub_job_function`, `SmallBusPerc`, `MedBusPerc`, `LargeBusPerc`, `ConsumerPerc`, `EducationPerc`, `GovernmentPerc`, `OtherPerc`, `sub_comments`) values ('$user_index', '$sub_firstname', '$sub_lastname', '$sub_company', '$sub_city', '$sub_prov', '$sub_country', 'NO', '$sub_type', '$sub_email', '$random_num', password('$password'), '$password', '$nl_version', 'pending', CURDATE(), CURDATE(), '$sub_job_function', '$SmallBusPerc', '$MedBusPerc', '$LargeBusPerc', '$ConsumerPerc', '$EducationPerc', '$GovernmentPerc', '$OtherPerc', '$sub_comments')"; if($result = mysql_query($sql)) { //the record was successfully entered. Need to enter his categories //now, we have to re-enter the category information. $categories = "select * from ecn_category where cat_include = 'Y' and cat_type != 'ECNTV'"; $cat_result = mysql_query ($categories); while ($cat_row = mysql_fetch_assoc($cat_result)) { extract ($cat_row); //need to insert one record for every category //check to see if the type is checked if (isset($$cat_id) | ($select_all == "All")) { //picking the variable of the category id... //insert a linked record $sql = "insert into ecn_usercatlink (`usercatlink_catid`, `usercatlink_user`) values ('$cat_id', '$user_index')"; $result = mysql_query($sql) or die(mysql_error()); echo "
Interested in $cat_name"; } } //now, let's add the news feeds $feeds = "select * from ecn_lists"; $feed_result = mysql_query($feeds); while ($feed_row = mysql_fetch_assoc($feed_result)) { $sql = "insert into ecn_subscriptions (`subscription_user`, `subscription_list`) values ('$user_index', '$feed_row[list_id]')"; $result = mysql_query($sql) or die(mysql_error()); } $subject="Please confirm your subscription to"; $email = $sub_email; $headers = "MIME-Version: 1.0\n" . "Content-Type: text/plain\n" . "From: Subscription Management\n" . "X-Priority: 3\n" . "X-MSMail-Priority: Normal\n" . "X-Mailer: PHP"; $body = "Dear $sub_firstname,\n\n" . "Thank you for subscribing to \n" . "In order to verify your subscription, you must click on the link below\n\n" . "$sub_email&v=$random_num\n\n" . "Once your subscription has been confirmed, you will be able to manage your subscription.\n" . "A confirmation email will be generated with all the information necessary to manage your subscription." . "Thanks again for subscribing."; mail($email,$subject,$body,$headers); echo "

Thank you, your subscription has been entered. A confirmation email has been sent to $sub_email" . ". You will need to click on the link provided to verify your subscription.
\n" . "If you have difficulties, please email us"; } else { ?>

Sorry, there's been an error. WE could not subscribe you because you have already subscribed to

Subscribe to e-ChannelNews

All Fields must be completed.


I would like to receive the iBiz10 e-newsletter.
  I would like to subscribe to e-ChannelNews Daily
I am a:
First Name:
Last Name:
Company Name:
Canada U.S.A. Other
verify e-mail
Verify Password

Which best describes your Job Function (select one).

Executive Management (CEO, President, Partner)
Corporate Management (Vice President)
Departmental Management (Purchasing, Operations, Admin)
Technical Management (Technical Staff)
Sales Management
Marketing Management
Sales Staff
Product Management
Channel Management

Please indicate topics of interest to you for E-ChannelNews: (check all that apply)

Select All Topics

$cat_name\n"; $i++; if ($i == 3) { echo "\n\n"; $i=0; } } ?>
HTML newsletter text newsletter

Please validate by copying 3239aBBa3 into this field:

Send us your comments

Please allow a few days to verify your application.

End User