To do a query before inserting data in mySQL

To do a query before inserting data in mySQL

El Forum
Unregistered

11-02-2008, 06:02 AM

[eluser]ray73864[/eluser]
set the 'email' column in the table to be 'unique', that way when you try to insert it will fail and then you can test for that fail using 'affected_rows()', if it failed then send them back to the form with what the values they had previously entered.

Messages In This Thread

To do a query before inserting data in mySQL - by El Forum - 11-02-2008, 05:30 AM

To do a query before inserting data in mySQL - by El Forum - 11-02-2008, 05:57 AM

To do a query before inserting data in mySQL - by El Forum - 11-02-2008, 06:02 AM

To do a query before inserting data in mySQL - by El Forum - 11-02-2008, 06:04 AM

To do a query before inserting data in mySQL - by El Forum - 11-02-2008, 07:38 AM

To do a query before inserting data in mySQL - by El Forum - 11-02-2008, 08:12 AM

To do a query before inserting data in mySQL - by El Forum - 11-02-2008, 08:30 AM

To do a query before inserting data in mySQL - by El Forum - 11-02-2008, 08:58 AM

To do a query before inserting data in mySQL - by El Forum - 11-02-2008, 02:52 PM

To do a query before inserting data in mySQL - by El Forum - 11-02-2008, 06:32 PM

To do a query before inserting data in mySQL - by El Forum - 11-03-2008, 01:37 AM

To do a query before inserting data in mySQL - by El Forum - 11-03-2008, 02:02 AM

To do a query before inserting data in mySQL - by El Forum - 11-03-2008, 04:09 AM