War Dogs Motorcycle Club - Member Add-View-Change

$value){ if ($key <> "memName" && $key <> "memNumber" && $key <> "memEmail" && $key <> "submit" && $key <> "memLevel" && $key <> "userID" && $key <> "userTableID" && $key <> "userPass" && $key <> "rideName" && $key <> "memOcc" && $key <> "memDesc" && $key <> "celNumber") { // echo $key.": ".$value."
"; $functionID = $value; $linkRES = mysql_query("insert into wd_functionlink (fl_fid, fl_mid) values ($functionID,$memID)") or die ("Update Linking Error: ".mysql_error()); } } } // add member if ($_GET["add"]){ // extract Vars $userID = $_POST["userID"]; $userPass = $_POST["userPass"]; $memLevel = $_POST["memLevel"]; $memName = $_POST["memName"]; $memRideName = $_POST["rideName"]; $memEmail = $_POST["memEmail"]; $memNumber = $_POST["memNumber"]; $celNumber = $_POST["celNumber"]; $memOcc = $_POST["memOcc"]; $memDesc = $_POST["memDesc"]; // add current entry into wd_user table $addID = "insert into wd_user ( u_name,u_pass,u_level) values ('$userID','$userPass','$memLevel')"; $IDresult = mysql_query($addID) or die ("Error in adding user to table: ". mysql_error()); $lastID = mysql_insert_id(); // add current entry into wd_member table $addMem = "insert into wd_member ( m_name,m_userid,m_email,m_hnumber,m_cnumber,m_occupation,m_desc,m_ridingname) values ('$memName','$lastID','$memEmail','$memNumber','$celNumber','$memOcc','$memDesc','$memRideName')"; $MemResult = mysql_query($addMem) or die ("Error in adding member to table: ". mysql_error()); $memID = mysql_insert_id(); // add functions to functionlink table foreach($_POST as $key => $value){ //print "$key => $value
"; if ($key <> "memName" && $key <> "memNumber" && $key <> "memEmail" && $key <> "submit" && $key <> "memLevel" && $key <> "userID" && $key <> "userPass" && $key <> "userTableID" && $key <> "rideName" && $key <> "memOcc" && $key <> "memDesc" && $key <> "celNumber") { // echo $key.": ".$value."
"; $functionID = $value; $linkRES = mysql_query("insert into wd_functionlink (fl_fid, fl_mid) values ($functionID,$memID)") or die ("Add Linking Error: ".mysql_error()); } } /* */ } ?> War Dogs Motorcycle Club - Member Add-View-Change

Scholarship Awards
From the 2007
Fallen Hero’s Run

Scholarship Awards
From the 2008
Fallen Hero’s Run

War Dogs
Support
Our Troops

John
"BIG DOG"
Challis

WARDOGS-MC DATABASE
Add-Change-View Member Information
MENU
Refresh Page

Member Form

NAME:

Access:

Riding Name:

UserID:

Password:

Home Number:

Email:

Cel Number:

Occupation:

Details:

"; for ( $f=1 ; ($fRow = mysql_fetch_array($funcRes)) ; $f++){ $f_id = intval($fRow["f_id"]); $f_function = $fRow["f_function"]; $flinkSel = mysql_query("select count(*) from wd_functionlink where fl_mid = $updID and fl_fid = $f_id"); $flinkRes = mysql_fetch_array($flinkSel); $flinkCount = $flinkRes["count(*)"]; ($flinkCount > 0) ? $chk = "checked" : $chk = ""; ($f%4 == 1) ? $begin = "" : $end = ""; print $begin."$f_function
".$end; } if (($f-1)%4 <> 0 ) { print ""; } ?>

" : $begin = "

"; ($f%4 == 0) ? $end = "

MANAGE FUNCTIONS

		name	ID	Password	Access	Email