déjà vu MRT and details page

Hi Guys, May I trouble you for a little help with my users_details page.

I have created a database to hold customer information along with a MRT table for listing of different product brand names which are selected by way of tick boxes.

Main Table `brands`
BrandID
BrandName
BrandIcon

Joining Table `userbrand`
UserBrandID
UserBrandUserID
UserBrandBrandID

User table `users`
UserID
UserEmail
Username
etc etc.

I have successfully used repeat regions and MRT to pull the correct information into my insert and update pages and store them correctlty in the DB. Where I am falling down is when I come to coding the details page.

I have wriiten what I believe to be the correct Sql statement joing the respective tables for output on the details page of the brand names; but sadly I am close but not getting the cookies (Sorry Ernie you will have ask Burt for some cookies this time)

Both my insert and update pages work with MRT but I have 2 issues. On the update page it shows the tick boxes for all the products brands (retrieved from the DB) but they are missing the previous seletected ticks to the chosen brands from the insert page.

My second issue is my userDetails Page. I have no output to this page for the chosen brand names.

on the detail pages I :
Added recordset to page `rsBrands`

Added SQL
SELECT brand.BrandName, users.UserID
FROM brand INNER JOIN userbrand ON brand.BrandID = userbrand.UserBrandBrandID
INNER JOIN users ON userbrand.UserBrandUserID = users.UserID
WHERE users.UserID = paramUserID

My Param is as follows
paramUserID
Integrer
-1
$_GET['UserID']

Added echo statements on details page

<?php do { ?>
<?php echo $row_rsBrands['BrandName']; ?> <strong>|</strong>
<?php } while ($row_rsBrands = mysql_fetch_assoc($rsBrands)); ?>

I would be very great full if someone with good grounding could advise.

I will upload my insert / update and details.

So many thanks to all in advance

Jonathon

Update Page: In the MRT Behaivor, the Master Key value should be using the UserID URL Variable instead of the WADA_Insert_users session variable.

Details Page:
in the rsBrands recordset, change the where clause:
WHERE users.UserID = paramUserID

to:
WHERE UserID = paramUserID OR ( -1= paramUserID2 AND UserID= paramSessionUserID)

and create the following variables:

Name: paramUserID
type: integer
default value: -1
Runtime Value: $_GET['UserID']

Name: paramUserID2
type: integer
default value: -1
Runtime Value: $_GET['UserID']

Name: paramSessionUserID
type: integer
default value: -1
Runtime Value: $_SESSION['WADA_Insert_users']

Hi Jason,

Thank you for coming to the rescue yet again.

Changes to the details page worked great.

However on the update page I am still not getting the tick boxes to populate from the database. If you have any idea's that i could try it would be very much appreciated.

Regards

Jonathon

please send the latest copy of the update page.

Attached as requested.

Many thanks Jason

Sorry, here it is.

the code for preselecting the options is duplicated,


delete the following code from lines 289 - 209:

<?php

// WA DataAssist Pre-Select Relational Table 1

$WA_PreSelect_RelationalTable_1 = array();

$WA_connection = $connFinder;

$WA_table = "userbrand";

$WA_masterKeyField = "UserBrandUserID";

$WA_masterKeyType = "',none,''";

$WA_masterKeyValue = "".$_SESSION['WADA_Insert_users']  ."";

$WA_masterKeyComp = "=";

$WA_joinedKeyField = "UserBrandBrandID";

$WA_connectionDB = $database_connFinder;

mysql_select_db($WA_connectionDB, $WA_connection);

$WhereObj = WA_AB_generateWhereClause(array($WA_masterKeyField), array($WA_masterKeyType), array($WA_masterKeyValue), array($WA_masterKeyComp));

$WA_Sql = "SELECT ".$WA_masterKeyField.", ".$WA_joinedKeyField." FROM ".$WA_table." WHERE ".$WhereObj->sqlWhereClause." ORDER BY ".$WA_joinedKeyField;

$WA_mrtJoinRS = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());

if (mysql_num_rows($WA_mrtJoinRS) > 0) {

  while ($row_WA_mrtJoinRS = mysql_fetch_assoc($WA_mrtJoinRS)) {

    $WA_PreSelect_RelationalTable_1[] = $row_WA_mrtJoinRS[$WA_joinedKeyField];

  }

}

?>

A VERY big Thank you