Filter recordset using PHP variable

[timgraham]

Is it possible to filter a recordset using a PHP variable.
I have tried to do this below, without success. The PHP variable is created from the first recordset, then I need to filter the second recordset with the new variable. I used the Dreamweaver option "filter by server variable". Is this the way to do it ?

Thanks For reading


$colname_find_user = "-1";
if (isset($_GET['cm'])) {
$colname_find_user = (get_magic_quotes_gpc()) ? $_GET['cm'] : addslashes($_GET['cm']);
}
mysql_select_db($database_mx_shop, $mx_shop);
$query_find_user = sprintf("SELECT * FROM order_ord WHERE id_ord = '%s'", $colname_find_user);
$find_user = mysql_query($query_find_user, $mx_shop) or die(mysql_error());
$row_find_user = mysql_fetch_assoc($find_user);
$totalRows_find_user = mysql_num_rows($find_user);

$user_id = $row_find_user['userid_ord'];

$colname_old_credits = "-1";
if (isset($_SERVER['$user_id'])) {
$colname_old_credits = (get_magic_quotes_gpc()) ? $_SERVER['$user_id'] : addslashes($_SERVER['$user_id']);
}
mysql_select_db($database_connblog, $connblog);
$query_old_credits = sprintf("SELECT * FROM tbl_users WHERE int_user_id = %s", $colname_old_credits);
$old_credits = mysql_query($query_old_credits, $connblog) or die(mysql_error());
$row_old_credits = mysql_fetch_assoc($old_credits);
$totalRows_old_credits = mysql_num_rows($old_credits);

[barand]

When you are looking up a value with one query then using that value in the WHERE clause of a second query the same result can usually be achieved with a single, joined query

$sql = "SELECT COUNT(*) as numcreds
    FROM order_ord o INNER JOIN tbl_users u
    ON o.userid_ord = u.int_user_id
    WHERE io.d_ord = '$colname_find_user' ";
$result = mysql_query($sql) or die(mysql_error());
$totalRows_old_credits = mysql_result($result, 0, 'numcreds');