Filtering Tables

Posted on 16th Feb 2014 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

Other forums