I have the same problem and have tried the solution above, however it's returning an empty recordset. My recordset is as follows:
<?php
$ParamClientID_WADAclients = "-1";
if (isset($_GET['ClientID'])) {
$ParamClientID_WADAclients = $_GET['ClientID'];
}
$ParamAccountantID_WADAclients = "-1";
if (isset($_SESSION['AccountantID'])) {
$ParamAccountantID_WADAclients = $_SESSION['AccountantID'];
}
mysql_select_db($database_new_greenroom, $new_greenroom);
$query_WADAclients = sprintf("SELECT AccountantID, ClientID, ClientName, StagingDate FROM clients WHERE ClientID = %s AND AccountantID = %s", GetSQLValueString($ParamClientID_WADAclients, "int"),GetSQLValueString($ParamAccountantID_WADAclients, "int"));
$WADAclients = mysql_query($query_WADAclients, $new_greenroom) or die(mysql_error());
$row_WADAclients = mysql_fetch_assoc($WADAclients);
$totalRows_WADAclients = mysql_num_rows($WADAclients);
?>
Any idea what might be wrong?