Filtering Tables

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

Hello Thanks for any help any one can give Im very new to PHP..

I need to pull data for clients that share 2 diff services into one table.

mysql_select_db($database_pull, $pull);
$query_Recordset1 = "SELECT * FROM RR_services WHERE USER_ID='XXXXX' and ( GAME_ID = 'RR6261678786234' or GAME_ID = 'RR4148833526812' )";
$Recordset1 = mysql_query($query_Recordset1, $pull) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>

This does what i need but i have to define the USER_ID i would like it to search all users and just display results of those that have both services..

Thanks

Your Answer:

Login to answer

Other forums

Multidimensional array problems in $_POST
I'm having trouble with a three-dimensional $_POST array. It starts as a two-dimensional array on th

Force download script not handling files with spaces properly
I have a regular old php force download script, uses this code:

Code: header("Cache-Cont

Having problemswith multithreading and prime numbers
I have an assignment when I'm suppose to do the following:

Write a multithreaded Java, Pt

Problem with coding MySQL query
I'm having heaps of trouble getting one of my PHP/MySQL queries to work for some reason (and the fun

Material xxx does not exist in plant xxx
Dear All,

I am working for a steel project which is repetitive manufacturing.

HTML Form Server Side Validation
Hi, Im new here, im currently doing a website for a friend, and I have designed using snippets from

IF STATEMENT HELP
Hi
i have created a calendar from a table:

Code: Calendar: October 2009
<table w

controlling/creating accounts with privileges
hi all,
i'm trying to figure out how i can create/control account with privileges, for instance a

My query is being run with no results.
I have this.

Code: function DropUser($duser_id, $user_email, $user_username) {

Checking if field is empty AND using !is_numeric
Hi lads,

Need to be able to display an error message (using isset?) that says "Cant lea