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

Display search result
Hi!

I have a SQL database with information about albums and track (music).

This is wh

PHP FTP connect doesn't work with correct login
Hi!

i am working on this test code:
Quote<?php

$ftp_ser

How do i use vars in an array
Hiya peeps!

How do I use a var in an array. You will see $id but it isnt working.

Extra fields in main body and php required.
I'm new to PHP so please be gentle. I have a little php script below that works well.
The &quo

User feedback after MySQL query has been executed
Hi all, I've just registered on PHPFreaks because I've got a question that I simply can't work out b

How do I use a global footer..?
If my index.php has a bole bunch of if functions and exit's in them

EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t

Print out contents of to Excel
I have got this script that gathers all the data that I need but I need it to send it to excel inste

INSERT for date range
Hi all

I have the following table

Code: [Select] `date` date
`day` int(2)
`

Find occurences of unicode characters in string
I need to prohibit filenames with everything but English characters and numbers but regexp and strin