Hi Ray, thanks for the help, things are looking good, Something I meant to check with you, on some earlier p[ages I created I did them before upgrading to Databridge 2. So the connection was <?php require_once('Connections/songwriters.php'); ?>. I have since created a new connection songwritersi. Do I have to recreate this whole page or can I simply change <?php require_once('Connections/songwriters.php'); ?> to <?php require_once('Connections/songwritersi.php'); ?> and adding <?php require_once('webassist/mysqli/rsobj.php'); ?> to the page as well.
Also two other places:
<?php
// WA DataAssist Insert
if (isset($_POST["RichRegistrationCountryCode_submit"]) || isset($_POST["RichRegistrationCountryCode_submit_x"])) // Trigger
{
$WA_connection = $songwriters; (would change songwriters to songwritersi here?)
$WA_table = "users";
$WA_sessionName = "register_id";
$WA_redirectURL = "confirm.php";
if (function_exists("rel2abs")) $WA_redirectURL = $WA_redirectURL?rel2abs($WA_redirectURL,dirname(__FILE__)):"";
$WA_keepQueryString = false;
$WA_fieldNamesStr = "Membership_type|UserFirstName|UserLastName|stagename|UserEmail|Password|UserCity|UserCountry|UserState|genre1|genre2|BIO|member_image|website|audio1|audio2|audio3|video1|video2|video3";
$WA_fieldValuesStr = "".((isset($_POST["Membership_type"]))?$_POST["Membership_type"]:"") ."" . $WA_AB_Split . "".((isset($_POST["First_Name"]))?$_POST["First_Name"]:"") ."" . $WA_AB_Split . "".((isset($_POST["Last_Name"]))?$_POST["Last_Name"]:"") ."" . $WA_AB_Split . "".((isset($_POST["AKA"]))?$_POST["AKA"]:"") ."" . $WA_AB_Split . "".((isset($_POST["Email_Address"]))?$_POST["Email_Address"]:"") ."" . $WA_AB_Split . "<".WA_SHA1Encryption(((isset($_POST["Password"]))?$_POST["Password"]:"")) ."" . $WA_AB_Split . "".((isset($_POST["City"]))?$_POST["City"]:"") ."" . $WA_AB_Split . "".((isset($_POST["Country"]))?$_POST["Country"]:"") ."" . $WA_AB_Split . "".((isset($_POST["State"]))?$_POST["State"]:"") ."" . $WA_AB_Split . "".((isset($_POST["genre1"]))?$_POST["genre1"]:"") ."" . $WA_AB_Split . "".((isset($_POST["genre2"]))?$_POST["genre2"]:"") ."" . $WA_AB_Split . "".((isset($_POST["BIO"]))?$_POST["BIO"]:"") ."" . $WA_AB_Split . "".((isset($_POST["image"]))?$_POST["image"]:"") ."" . $WA_AB_Split . "".((isset($_POST["url"]))?$_POST["url"]:"") ."" . $WA_AB_Split . "".((isset($_POST["audio1"]))?$_POST["audio1"]:"") ."" . $WA_AB_Split . "".((isset($_POST["audio2"]))?$_POST["audio2"]:"") ."" . $WA_AB_Split . "".((isset($_POST["audio3"]))?$_POST["audio3"]:"") ."" . $WA_AB_Split . "".((isset($_POST["video1"]))?$_POST["video1"]:"") ."" . $WA_AB_Split . "".((isset($_POST["video2"]))?$_POST["video2"]:"") ."" . $WA_AB_Split . "".((isset($_POST["video3"]))?$_POST["video3"]:"") ."";
$WA_columnTypesStr = "',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''";
$WA_fieldNames = explode("|", $WA_fieldNamesStr);
$WA_fieldValues = explode($WA_AB_Split, $WA_fieldValuesStr);
$WA_columns = explode("|", $WA_columnTypesStr);
$WA_connectionDB = $database_songwriters; (and here as well?
thanks Brian
mysql_select_db($WA_connectionDB, $WA_connection);
@session_start();
Thanks Brian