Skip navigation
iffyniffy
iffyniffy Calculating status...
Currently Being Moderated

Need help with filtering dynamic data

Jun 14, 2012 8:36 AM

Hi everyone.


Iv just build my shop website using dreamweaver. Everything is fine, works well, but now iv been asked to add the option to filter products by brand and im now stuck.


The website is Climatise: Home (i know the css is a bit of a mess but it works)


I simply don't know how to get this to work as the brand name is part of a field with other stuff in it.


Thanks for looking.

357 Views   2 Replies   Latest reply: megaman_thesecond, Jun 14, 2012 5:10 PM
 
Replies
  • Ben Pleysier
    Currently Being Moderated
    1. Ben Pleysier,
    Jun 14, 2012 4:53 PM   in reply to iffyniffy
    Report

    Add a numerical field called brand where you can add the number corresponding to the brand. Create a new table called brands with two fields, ID and brand_name, the ID has an automatic counter.

     

    Gramps

     
    |
    Mark as:
  • megaman_thesecond
    Currently Being Moderated
    2. megaman_thesecond,
    Jun 14, 2012 5:10 PM   in reply to Ben Pleysier
    Report

    Altruistic Gramps wrote:

     

    Add a numerical field called brand where you can add the number corresponding to the brand. Create a new table called brands with two fields, ID and brand_name, the ID has an automatic counter.

     

    Gramps

     

    That is a excelent solution if the OP has a site which has a lot of data or is likely to exapand quickly in the future

     

    However it may be that a better solution would be to add a text field called brand and put the brand name in that -  no faffing about with linking brands to a number and having two seperate tables.

     

    the advantage of this is that there would be no need for each brand to equal an integer
    The dissadvantage would be that without a table which works like a relationship table to connect fields future expansion will be more difficult

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points