It all depends how your database is setup and you level of
sql
experience. One way is to start out with what you know will
work but
you know in your heart it is not effieicent. Once you get the
data you
want, acquire a good book or two and experment. If you keep
at it you
will get better.
fbcojman wrote:
> I am trying to pull from multiple tables in a mySQL
database using
> PHP. I'd like to have various sets of information on a
membership
> page i am building to include the specific info about a
member, which
> is in one table, and the payment history from that
member, which is a
> one to many relationship in another table. Should i use
multiple
> recordsets to accomplish this or is there a SQL
statement that will
> satisfy? When i tried to set it up, i got only a couple
listings
> because certain members did not have any data associated
in the
> payment table. Any help or guidance is much appreciated.
>
> Thanks
>
> Josh
--
1
Reply
AdChoices