$value){ if ($key <> "memName" && $key <> "memNumber" && $key <> "memEmail" && $key <> 'memDesc' && $key <> "submit") { // echo $key.": ".$value."
"; $functionID = $value; $linkRES = mysql_query("insert into wd_functionlink (fl_fid, fl_nid) values ($functionID,$memID)") or die ("Linking Error: ".mysql_error()); } } } // add member if ($_GET["add"]){ // extract Vars $memName = $_POST["memName"]; $memNumber = $_POST["memNumber"]; $memEmail = $_POST["memEmail"]; $memDesc = $_POST["memDesc"]; // add current entry into wd_network table $addID = "insert into wd_network ( n_name,n_number,n_email,n_desc) values ('$memName','$memNumber','$memEmail','$memDesc')"; $IDresult = mysql_query($addID) or die ("Error in adding contact: ". mysql_error()); $contactID = mysql_insert_id(); foreach($_POST as $key => $value){ if ($key <> "memName" && $key <> "memNumber" && $key <> "memEmail" && $key <> "memDesc" && $key <> "submit") { // echo $key.": ".$value."
"; $functionID = $value; $linkRES = mysql_query("insert into wd_functionlink (fl_fid, fl_nid) values ($functionID,$contactID)") or die ("Linking Error: ".mysql_error()); } } } ?> War Dogs Motorcycle Club - Contact Add-View-Change
Contact Us Home Page
Why War Dogs
Symbolism
Is the Club Right for Me
Prospecting
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 Contact Information
MENU


Contact Form
NAME:
Number:
Email:
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_nid = $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 Email Number Function(s)
Edit Contact Info Delete Contact