[thelist] mySql question...

Marc Seyon seyon at delime.com
Thu Aug 28 08:46:13 CDT 2003


Message from jsWalter (8/28/2003 12:15 AM)

>If I have 2 fields, f1 and f2
>
>I do an INSERT on f1, but don't give f2 anything, I want the db to
>auto-magically copy the data from f1 and insert it into f2.
>
>Any ideas?

If I understand what you're trying to do, a simple conditional clause 
should work for you. When validating your form data check whether f2 is 
blank. If it is, make f2 = f1. Then proceed with your sql as usual.

regards.
-marc

--
Carnival 2003 in all its photographic glory. Playyuhself.com
http://www.playyuhself.com/


More information about the thelist mailing list