close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

déjà vu MRT and details page

Thread began 8/17/2011 5:27 pm by Jon Cunningham | Last modified 8/18/2011 10:08 am by Jon Cunningham | 1905 views | 7 replies

Jon CunninghamBeta Tester

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

Attached Files
users_Update.zip

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...