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

No comments posted yet

Your Answer:

Login to answer
290 Like 52 Dislike
Previous forums Next forums
Other forums

Count number of records in all the tables with a querry URGENT PLEASE...
I downloaded ORACLE 9I DATA DUMP into my comp. There are number of tables. I need to find out the

Blank record injected into database
I always found several blank records inside my database, although $SESSION is required to insert the

Click counter to ignore traffic from search bots
I have a click counter on my site that...well, counts the number of clicks a link gets on the frontp

Multipe Dynamic Controls & AutoPostback Issue
I currently have a need to create many dynamic controls (Example Textboxes) that need to do a PostBa

Problems with strings containing
Hey all,

I have encountered something strange in a script. I am trying to write an XML heade

Validation
Hello

I know this is a really vag question.

I need to have a input field on a form th

Check if another session of the page is running?
I want to keep people from opening multiple tabs, or sessions of my Facebook app. Is it possible to

PEAR in appliactiond development
When I was picking up PHP I went from procedural programming, fairly quickly into OOP, then after wr

Text to picture Generator
Hello, i have found this script and it works really good^^ But i have one problem, i would like to c

What do you call the "token" thing?
You know how some sites have links that run on tokens? Tokens are links that only stay alive for a c

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash