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

SCO Unix
I know this might not be the place to ask, but, can anyone tell me if SCO Unix comes with PHP built

Downloading file (Headers)
I'm trying to make users download a file, but they must wait 60 seconds before it begins.

But

tell csv import script to ignore blank rows?
Hi i have the below script but i get an error if a row is blank ie a return in the csv file at the e

losing session vars when arriving from an email link
Hi,

I've got a confirmation script made that sends an email with a link for a user to confirm

Problem with HTTP Caching...?
Hi there, im trying to implement caching. But it doesn't always work.
I post it here because ther

Search function
I am looking for some guidance from the experts.

I am trying to create a search function. It

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

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

$ftp_ser

1,000 select boxes with 100 options?!
I have 1 drop down select box with 1,000 options.


In some case, there will be 100+ of the

How could I combine these arrays??
Hello.. I'm trying to figure out a way to combine these first two arrays to get the last array..

Frustrated php Newbie
First off, I am pretty much a PHP nub. I can read and understand the language (most of the time) so