View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

items set up by color

Thread began 5/13/2009 5:55 pm by JBWebWorks | Last modified 10/15/2009 11:48 am by JBWebWorks | 4938 views | 37 replies


My thought process (besides being fried) is this.
I have the recordset, itemscat3, to loop through filtered by itemcatID (category 3)
the repeat region loops the items recordset
create the recordset, colors, to show the items color options (not sure if my sql is correct) this is the sql (SELECT *
FROM items, colors, color_lookup
WHERE color_lookup.item_colorID = myfakevar) runtime value of myfakevar is $_POST['myfakevar']
(here i am fuzzy) i dynamically populate the select list with the colors recordset with label and value as colors
end the loop is at the bottom of the page

i moved what i think is the recordset, colors, inside the recordset (after the PHP do code)
as far as the myfake variable, my thinking is i am telling what the variable should be with the code
$_POST['myfakevar'] = $row_rs_itemscat3['item_colorID'];
so in effect the sql filtering the recordset, colors, now says that color_lookup.item_colorID is equal to items.item_colorID which should filter the options of colors by the record of items.

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





Ease of use


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...