If data exists in the field print, else don't

If data exists in the field print, else don't

El Forum
Guest

#31

07-03-2009, 08:16 AM

[eluser]jedd[/eluser]
Actually, I'm regretting now not pushing to have the distinction between student and guardian somewhat blurred - or rather, made in a different way to having two similar tables - as it's just going to get messier having all people having addresses, emails, phone numbers and so on - but having to double up on each of those connecting tables.

I'll run it through the background processing part of my brain, but my thought now is table to combine student / parent:
person: [ id , type , fname , lname ]

type could be ENUM or just a CHAR and obviously denotes parent or student.

Messages In This Thread

If data exists in the field print, else don't - by El Forum - 07-01-2009, 05:00 PM

If data exists in the field print, else don't - by El Forum - 07-01-2009, 05:28 PM

If data exists in the field print, else don't - by El Forum - 07-01-2009, 06:15 PM

If data exists in the field print, else don't - by El Forum - 07-01-2009, 06:24 PM

If data exists in the field print, else don't - by El Forum - 07-01-2009, 06:36 PM

If data exists in the field print, else don't - by El Forum - 07-01-2009, 06:52 PM

If data exists in the field print, else don't - by El Forum - 07-01-2009, 09:00 PM

If data exists in the field print, else don't - by El Forum - 07-01-2009, 09:12 PM

If data exists in the field print, else don't - by El Forum - 07-01-2009, 09:13 PM

If data exists in the field print, else don't - by El Forum - 07-01-2009, 09:50 PM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 03:20 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 03:29 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 03:40 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 05:51 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 08:02 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 08:16 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 08:22 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 08:31 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 08:34 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 09:16 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 01:07 PM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 01:22 PM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 01:23 PM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 03:29 PM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 03:37 PM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 05:09 PM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 12:44 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 12:55 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 03:58 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 08:01 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 08:16 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 09:00 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 09:33 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 09:49 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 10:01 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 10:08 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 11:01 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 11:08 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 11:38 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 11:53 AM