Please help with SQL!

Results 1 to 2 of 2

Thread: Please help with SQL!

  1. #1
    Jut Guest

    Default Please help with SQL!

    Hi Guys & Gals,<BR> I was wondering if one of you could help me out with a little SQL. Heres what I am trying to do:-<BR><BR>I have 2 tables in my Database. 1 Called Content, 1 called registration.<BR>Both have various fields in. One of the fields in registration is &#039State&#039.<BR><BR>Now, what I am trying to do, is display only the data from &#039Content&#039relating to the field &#039State&#039 in &#039Registration&#039.<BR>For example, if somebody went to the Florida section of the site, they would<BR>only see information posted by a person who when registering, entered &#039Florida&#039 in the &#039State&#039 field of the registration form. Do you get what I<BR>mean?<BR><BR>Thanks in advance,<BR><BR>Jut.<BR>

  2. #2
    estie Guest

    Default RE: Please help with SQL!

    "select * from content, registration where registration.state="&variable<BR>variable would be the different state, depending on the part of the site.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts