Results 1 to 5 of 5

Thread: MySQL query [Resolved]

Threaded View

  1. #1

    Thread Starter
    Retired G&G Mod NoteMe's Avatar
    Join Date
    Oct 2002
    Location
    @ Opera Software
    Posts
    10,190

    MySQL query [Resolved]

    I am having problems with a query. It looked like this (here it works):

    Code:
    $resultat = mysql_query("select fArrID, fBy, fDato, fSted, fNavn, fText, fBildebox from fremover where fBy like 'B' and fDato >= ".$StartDato." ORDER BY fDato",$db);
    But I also want it to catch those where "fBy like 'A'

    I tried this:

    Code:
    $resultat = mysql_query("select fArrID, fBy, fDato, fSted, fNavn, fText, fBildebox from fremover where fBy like 'A' or where fBy like 'B' and fDato >= ".$StartDato." ORDER BY fDato",$db);
    and this

    Code:
    $resultat = mysql_query("select fArrID, fBy, fDato, fSted, fNavn, fText, fBildebox from fremover where fBy like 'A' or fBy like 'B' and fDato >= ".$StartDato." ORDER BY fDato",$db);
    But no luck...any idea?
    Last edited by NoteMe; Jul 24th, 2004 at 12:10 PM.

Posting Permissions

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



Click Here to Expand Forum to Full Width