I'm trying to pull information from a table as follows:

        Table: PHONE

PhoneClass      Number
Fax             123-123-1234
Main            123-123-1234
Fax             123-123-1234
Main            123-123-1234

etc.....

Main is mapped as phone
Fax is mapped as fax

I'm outputting this information on a form that has mapped fields.  The
problem here is that I cant change the table names to correspond to the
mapped fields already created.  Therefore, I wont to be able to pull this
information seperatly.  Wanted to know if there is any sql that will allow
me to pull this separetly......

Thanks,

Edward V. Hayes II
Medical/Manager WebMD


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to