MySQL query [Resolved]

[NoteMe]

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

$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:

$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

$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?

[techgnome]

Not sure about mySQL, but in MSSQL or evben Access, when you use the LIKE clause, don't you need to include some kind of wildcard character??

LIKE '*A*' or LIKE 'B*'

???

TG

[NoteMe]

I just tested without WHERE once more, and then suddenly the warning dissapeared...but it is still just picking the once with B and not the once with A..


Tried your solution, but it didn't help techgnome. It worked with just 'B' in it, but I still can't get the 'A's to work with it..

[Acidic]

hhm.. I know this is a terrible work around, but you could do two queries, then combine the arrays.

[NoteMe]

Yeah I could...but the ultimate solution in the end was trying one thing then go back...and suddenly it worked with the last solution I posted in my first post...I have NOOO idea why...maybe it did flush the cache corectly or something....bad bad bad...at least now it works...so I am not touching it again....thanks to all of you..