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

Your Answer:

Login to answer

Other forums

how to put the 0-100 numbers into 1.txt and 100-200 into 2.txt ?
how to put the 0-100 numbers into 1.txt and 100-200 into 2.txt and so on 200-300 into file 3.txt ?

switch not getting value
what am i doing wrong?
i want to populate the country list according to the category
i want to

Question about the upload of large files
Hi there,

I have a question about the upload of large files, like videos (files generally abo

Time script, set to my time zone?
I am using this line to get the date and time

Code: $time = date(F." ".d.", &q

ldap connection
We are using ldap to get user information from the domain controller. It was working before. Recentl

bind error during socket programming
i am kinda new to socket programming. wrote the below code for a server. but getting the bind error

how to export excel file in same server
My first post - php newbie, so appreciate your support.

I'm currently using headers to save w

RTF fomatting to email content
Im trying to sen an email with content is picked up from a rtf-file (file_get_contents('*.rtf'). Mai

Socket Server
In my following socket server, I am trying to listen to a connection through port 12345 in my web br

Logic question
im wondering what's the best method to do the above list:

it is for alliance @ MMORPG game