Skip to main content
P
Prellyan_Luxtintner
Inspiring
February 12, 2008
Question

slect runtime variable

  • February 12, 2008
  • 1 reply
  • 249 views
Hey there,

I have a recordset A which returns X variable on a standard clientID filter which then forms part of a repeat region.
As part of this data set i wish to include a field from a different table based on the returned X of recordset A and the returned recordset of B which is a Y/N query

Is there a way to do this and if yes how so.

Thanks
This topic has been closed for replies.

1 reply

P
Prellyan_LuxtintnerAuthor
Inspiring
February 12, 2008
so far i have this which might give a better explanation

$colname_albumimage = "-1";
if (isset($GET_['albums.albumID'])) {
$colname_albumimage = $_GET_['albumfilter.albumID'];
}
mysql_select_db($database_rubymain, $rubymain);
$query_albumimage = sprintf("SELECT pictures.picfilepath FROM pictures WHERE pictures.albumimage = 'Y' AND pictures.albumID = %s", GetSQLValueString($colname_albumimage, "int"));
$albumimage = mysql_query($query_albumimage, $rubymain) or die(mysql_error());
$row_albumimage = mysql_fetch_assoc($albumimage);
$totalRows_albumimage = mysql_num_rows($albumimage);
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices