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