drop table `ss_smart_staff`
Alter table `TABLE 45` rename to `ss_smart_staff`

update some column value into table
UPDATE `ss_user` SET `WIL`=1,`RDI`=1 WHERE UserID = 1

global $wpdb;
$strSQL = “SELECT name,username,Status FROM cipaefep_wordpress_v.ss_user WHERE username = ‘”.$_POST[‘txtUsername’].”‘
and password = ‘”.$_POST[‘txtPassword’].”‘”;
#echo $strSQL ;
$results = $wpdb->get_results($strSQL);
#$results = $wpdb->get_results(“SELECT name,username,Status FROM cipaefep_wordpress_v.ss_user WHERE username = ‘ohtingly’ “);
foreach($results as $objResult ) {
echo $objResult ->username .” “. $res->name ;
}

$_SESSION[“UserID”] = $objResult ->username;
$_SESSION[“Name”] = $objResult ->name;
$_SESSION[“Status”] = $objResult->Status;

call new page
$CookieName = “TestCookie”;
$RedirectURL = “https://www.smart2015.co.th/user_page_ss/”;
if( empty($_COOKIE[$CookieName]) ) { echo ““; }