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

Count on multidimensional array
Hi, i got an array as below:

Array
(
=> Array
(

Deleting pointers froms vector?
Hi. I have a vector filled with pointers and I want to delete the pointers. I could do a loop and do

BSP Ext - tableView - Sort - NEWBIE
Hi,
I have been trying to get the sort to work. I have defined the column definitions by fillin

How to limit the calls to an API
Hello, in my simple script I call an api which effectively involves me getting an xml file.

H

convert pps to wsf with php'how?
hi
i want to convert with php
PowerPoint file to swf file(flash)
how please?
thank!!!

Weekly Calendar
Hi, I am looking at creating a weekly calendar. The calendar will read from Monday - Sunday. Does an

php slowing my site?
Hi all,

I think that one of the reasons that my site doesn't work fast is that the code is ve

Beginners syntax and loop questions - help please!
Hi everyone,

I have some problems with php code. I'm currently in the middle of learning php,

Images in email problem
I found this script for sending emails, it works but if the email has <img src="image.jp

PHP Code reffering to database, doing something wrong.. pls help
Well i am quite new with PHP
and for school we have to make a PHP script which reffers to a Data