executeQuery($SQL); $member = mysql_fetch_object($DB->result); $SQL = "SELECT * FROM address WHERE id=$member->shipAddrID"; $DB->executeQuery($SQL); $shipAddr = mysql_fetch_object($DB->result); $SQL = "SELECT * FROM address WHERE id=$member->billAddrID"; $DB->executeQuery($SQL); $billAddr = mysql_fetch_object($DB->result); $SQL = "SELECT * FROM crdt WHERE id=$member->cardID"; $DB->executeQuery($SQL); $cardInfo = mysql_fetch_object($DB->result); displayTop(); youAreHere("My Account"); ?> My Information
Edit My Information
My purchase History

's Information Back to Top
User Email :
User Name:
User DOB :	N/A
Shipping Address :	userName) echo "$shipAddr->userName $shipAddr->addr1, $shipAddr->addr2 $shipAddr->city, $shipAddr->state $shipAddr->zip"; else echo "N/A"; ?>
Billing Address :	userName) echo "$billAddr->userName $billAddr->addr1, $billAddr->addr2 $billAddr->city, $billAddr->state $billAddr->zip"; else echo "N/A"; ?>
Payment Method :	cn) { $cn = "***-". substr($cardInfo->cn, -5); $csecurenum = "**-". substr($cardInfo->csecurenum, -1); echo "Card Holder : $cardInfo->cholder Card Info : $cn, $cardInfo->cexpm / $cardInfo->cexpy ($csecurenum)"; } else echo "N/A"; ?>
Join Date :
Last Login Time :
Last Login IP :
Login num :	0 times

executeQuery($SQL); if($DB->rowno>0) { echo ""; echo ""; } ?> executeQuery($SQL); if($DB->rowno>0) { echo ""; echo ""; } ?>

Edit Information Back to Top
User Name:
User DOB :	(mm/dd/yyyy) EX: 03/28/1970
User Email :
Addresses :	"; while($row = mysql_fetch_object($DB->result)) { $address = "$row->userName, $row->addr1, $row->addr2, $row->city, $row->state, $row->zip"; $selected = ($row->id == $member->shipAddrID) ? " selected " : ""; echo "$address"; } echo "
New Address    Name on Address :
Address :
City, State, Zip :	,
Telephone :	Home : , Mobile :
Credit Cards :	"; while($r = mysql_fetch_object($DB->result)) { $card = displayCreditCardInformation($r->cholder, $r->cn, $r->cexpm, $r->cexpy, $r->csecurenum, 'N'); $selected = ($r->id == $member->cardID) ? " selected " : ""; echo "$r->id | $card"; } echo "
New Card    Card Holder :
Credit Number :
Expire Date :	Month $expM"; } ?> / Year $i"; ?>
Security Num :

Purchase History Back to Top

executeQuery($SQL); if($DB->rowno==0) { echo " No History Available! "; } else { echo " "; $ct = 1; while($row=mysql_fetch_object($DB->result)) { $total = sprintf("$%.2f", $row->totalCharge); echo " "; $ct++; } echo "   Purchase ID Purchase Date Total Status $ct $row->pID $row->pDate $total $row->pStatus "; } ?>