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

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

El Forum
Guest

#36

07-03-2009, 10:08 AM

[eluser]slowgary[/eluser]
I usually have the wrong end of the stick (something smells like pooh). Using a table name prefix for foreign keys only makes sense, but what would you do for zebakes case where he has a students table and a guardians table, and each have fields like 'fname', 'lname'. Or would you argue as mentioned that students and guardians should both be in one table? It makes sense to combine them, I would just have a much harder time I think getting the query right, looking for results like this:

Code:
student_id | student_lname | student_fname | guardian_lname | guardian_fname | guardian_phone

And this will still probably need a bunch of ASses (pooh-stick) to rename the fields.

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