View Single Post
  #6  
Old 08-10-2004, 08:13 AM
  B00MER's Avatar 
B00MER B00MER is offline
 

X-Guru
  
Join Date: Sep 2002
Location: Keller, TX (Cart-Lab.com)
Posts: 3,165
 

Default

Quote:
Originally Posted by mizzlewillz
One question , it has probably been answered before, but how would you check to see if an e-mail address already exists and stop another person from registering an identical e-mail address.

Go into phpMyAdmin and set the email field to "Unique" and MySQL will take care of it for you OR login to X-Cart and use the following MySQL code snippet in the Patch SQL area:

Code:
ALTER TABLE `xcart_orders` ADD UNIQUE ( `email` ); ALTER TABLE `xcart_customers` ADD UNIQUE ( `email` );

You may need to add some error catching in include/register.php but atleast noone can register the same email twice.
__________________
Cart-Lab - 100+ Social Bookmarks for X-Cart.
Reply With Quote