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

Question about the upload of large files
Hi there,

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

array_diff weirdness
I'm using the following bit of code

$diff = array_diff($pids, $pidlist);
$diff = array_va

Will an XHTML DOCTYPE interfere with my PHP if I'm not experienced enough?
I've read this article here: http://friendlybit.com/html/why-xhtml-is-a-bad-idea/

In a nutshe

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec

array_combine() trouble w/csv file
I have a problem with a piece of code I wrote to import some records from a csv file into mysql. I h

remove innitial

and

tags
i am using tiny_mce as a text editor for my CMS.
buy now the problem is it add <p>

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

Spliting paragraph into sentences and attach in
Here is what I am trying to do

example: Para1[123.456.789!] 3 sentences
Para2

this code is not working????
it says this error.. Warning: Division by zero in ..

the variables are correct, so why is th

PHP Redirecting
Hello everyone. Is there a way to redirect people to pages within a statement in PHP? Since there is