Need Help with a query


Posted on 16th Feb 2014 07:03 pm by admin

Hello,
For some reason I am just not getting the right answer when I do this query and not quite sure why?
$runinposition = mysql_query("SELECT * FROM bb_off WHERE user='$user' AND test1='test1' OR test2='test' OR test3='test3' OR test4='test4' OR test5='test5' OR test6='test6' AND Result1='result1'OR Result2='result2' OR Result3='result3'OR Result4='result4'");
$runinpositionresult= mysql_num_rows($runinposition);

So, basically what I am trying to do is count how many test there are when the user = the user and one of the results???

No comments posted yet

Your Answer:

Login to answer
172 Like 42 Dislike
Previous forums Next forums
Other forums

Greek characters in php
Hi,

I'm making a script and I m using for first time greek characters.
I started to write

Extracting Long text from message class with parameters
Hi,

I would like to extract the long text from a message class. However, the long text ha

check comment for html
hi, I just wanted to check if a comment a user posts contains HTML, and if it does, to not allow it

same querie, or a new one??
Hi guys,

I'm still working on this drop down list. I've got the actual drop down list to wor

RSS poster script?
I have found a script that posts RSS's for me on a site that I'm building. However I would like to a

writing my own sobel filter convolution - something is wrong
I am trying to keep it very simple, I cant see anything wrong with my logic, could anybody help poin

Count of reciepients in php mailer
How can i sent a mail to large no of reciepients say 10,00,00 Using PHP MAILER

Can we convert non uni code system into unicode
Hi All,

Presently i am using non-unicode system and the sap version is 4.7.
Can i c

Image resize
Hi again fellers

I managed to sort out the issues with the folder,

Final hurdle is th

javascript in php code causes page to display white
Hi All,

Odd one this, I've got the following code (below) which is a simple log in form. The

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash