This is a multi-part message in MIME format.
------=_NextPart_000_020D_01BFEDCB.FCC0C8E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
First, have them choose a password when they first come in. When they =
return, ask them for their e-mail and password. E-mail should be a =
unique field anyways. If they choose to ignore the login and decide to =
put in new information, run a select query on your bill/ship table =
matching the e-mail addresses. If the e-mail address doesn't exist, add =
as usual; however, if the e-mail address already exists, give the user a =
warning that a user with that e-mail has already registered and that if =
they would like to have their password resent, "click here". Then, once =
they login, you give them the option to edit their information.
Best of luck
Dave
David Fried
VP Software Development
BrainDock.com
110 Greene Street, ph2, NYC 10012
v +1.212.271.9056
f +1.212.274.8527
email: [EMAIL PROTECTED]
web: www.braindock.com =20
=20
----- Original Message -----=20
From: "Chris Farrugia" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 14, 2000 6:57 PM
Subject: Adding Customers to a database
> Hello Everyone,
>=20
> I am building a site where a customer can configure a new computer and =
then
> place the order. I have it up to the point where they type in their
> information (shipping address, billing address, credit card info), and =
this
> will all be stored in a database. HOwever, I thought this part would =
be
> easy enough to do, but I can not think of how to check to see if they
> already have a record in my database. If they are already in my =
database, I
> don't want to re-add them... but if they are in there, and they have a
> different shipping address, I need to change the database. Any =
suggestions
> on how to accomplish this? Thank you for the help.
>=20
> Sincerely,
> Chris Farrugia
>=20
> =
-------------------------------------------------------------------------=
-----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit =
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta=
lk or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in the body.
------=_NextPart_000_020D_01BFEDCB.FCC0C8E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT size=3D2>First, have them choose a password when they first =
come=20
in. When they return, ask them for their e-mail and =
password. =20
E-mail should be a unique field anyways. If they choose =
to=20
ignore the login and decide to put in new information, run a select =
query on=20
your bill/ship table matching the e-mail addresses. If the e-mail =
address=20
doesn't exist, add as usual; however, if the e-mail address already =
exists, give=20
the user a warning that a user with that e-mail has already registered =
and that=20
if they would like to have their password resent, "click here". =
Then, once=20
they login, you give them the option to edit their =
information.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Best of luck</FONT></DIV>
<DIV><FONT size=3D2>Dave</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>
<DIV><FONT face=3DTahoma>
<TABLE cellPadding=3D2 width=3D"100%" border=3D0>
<TBODY>
<TR>
<TD vAlign=3Dtop width=3D"50%">
<DIV><FONT face=3D"Tahoma, Arial, Helvetica, sans-serif" =
color=3D#666666=20
size=3D1><B>David Fried</B></FONT></DIV>
<DIV><FONT face=3D"Tahoma, Arial, Helvetica, sans-serif" =
color=3D#666666=20
size=3D1><STRONG>VP Software=20
Development<BR><BR><BR></STRONG></DIV></FONT></TD>
<TD vAlign=3Dtop align=3Dright width=3D"50%"><FONT=20
face=3D"Tahoma, Arial, Helvetica, sans-serif" color=3D#666666=20
size=3D1><B>BrainDock.com</B></FONT><BR><FONT=20
face=3D"Tahoma, Arial, Helvetica, sans-serif" color=3D#666666 =
size=3D1>110=20
Greene Street, ph2, NYC 10012<BR>v +1.212.271.9056<BR>f=20
+1.212.274.8527<BR>email: </FONT><A=20
href=3D"mailto:[EMAIL PROTECTED]"><FONT=20
face=3D"Tahoma, Arial, Helvetica, sans-serif" color=3D#666666=20
size=3D1>[EMAIL PROTECTED]</FONT></A><FONT=20
face=3D"Tahoma, Arial, Helvetica, sans-serif" color=3D#666666 =
size=3D1><BR>web:=20
</FONT><A href=3D"http://www.braindock.com/"><FONT=20
face=3D"Tahoma, Arial, Helvetica, sans-serif" color=3D#666666=20
size=3D1>www.braindock.com</FONT></A><FONT=20
face=3D"Tahoma, Arial, Helvetica, sans-serif" color=3D#666666 =
size=3D1>=20
</FONT></TD></TR></TBODY></TABLE><BR></FONT><FONT face=3DArial =
color=3D#0000ff=20
size=3D2><SPAN =
class=3D997175416-27032000> </SPAN></FONT></DIV></FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>----- Original Message ----- </FONT></DIV>
<DIV>
<DIV><FONT size=3D2>From: "Chris Farrugia" <</FONT><A=20
href=3D"mailto:[EMAIL PROTECTED]"><FONT=20
size=3D2>[EMAIL PROTECTED]</FONT></A><FONT =
size=3D2>></FONT></DIV>
<DIV><FONT size=3D2>To: <</FONT><A=20
href=3D"mailto:[EMAIL PROTECTED]"><FONT=20
size=3D2>[EMAIL PROTECTED]</FONT></A><FONT =
size=3D2>></FONT></DIV>
<DIV><FONT size=3D2>Sent: Friday, July 14, 2000 6:57 PM</FONT></DIV>
<DIV><FONT size=3D2>Subject: Adding Customers to a =
database</FONT></DIV></DIV>
<DIV><FONT size=3D2><BR></FONT></DIV><FONT size=3D2>> Hello =
Everyone,<BR>>=20
<BR>> I am building a site where a customer can configure a new =
computer and=20
then<BR>> place the order. I have it up to the point where they =
type in=20
their<BR>> information (shipping address, billing address, credit =
card info),=20
and this<BR>> will all be stored in a database. HOwever, I =
thought this=20
part would be<BR>> easy enough to do, but I can not think of how to =
check to=20
see if they<BR>> already have a record in my database. If they =
are=20
already in my database, I<BR>> don't want to re-add them... but if =
they are=20
in there, and they have a<BR>> different shipping address, I need to =
change=20
the database. Any suggestions<BR>> on how to accomplish =
this? =20
Thank you for the help.<BR>> <BR>> Sincerely,<BR>> Chris=20
Farrugia<BR>> <BR>>=20
-------------------------------------------------------------------------=
-----<BR>>=20
Archives: </FONT><A=20
href=3D"http://www.mail-archive.com/[email protected]/"><FONT=20
size=3D2>http://www.mail-archive.com/[email protected]/</FONT></A=
><BR><FONT=20
size=3D2>> To Unsubscribe visit </FONT><A=20
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"><FONT=20
size=3D2>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk</FONT></A><FONT=20
size=3D2> or send a message to </FONT><A=20
href=3D"mailto:[EMAIL PROTECTED]"><FONT=20
size=3D2>[EMAIL PROTECTED]</FONT></A><FONT size=3D2> =
with=20
'unsubscribe' in the body.</FONT></BODY></HTML>
------=_NextPart_000_020D_01BFEDCB.FCC0C8E0--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
