SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Member
    Join Date
    Feb 2005
    Posts
    21
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    FRAMESET + PHP + MySql product catalog(I need some advice)

    I need some advice how I should build my site.

    I was thinking of to make two frames.

    • One menu frame on the left
    • And main frame on the right


    On the menu frame I was thinking to make links for products and on the right frame the results that the link gives. I'm targeting all the links to main frame, so they will open there.

    I'm going to try to build a MySql query that gets the results from database to an nice table.

    Here comes the tricky part:

    I wouldn't like to make 30 php files for every product categories.

    Is there a way to get the title of the left-frames menu url on my SQL-query?

    For example:

    I click a productcategory link "airplanes" and it opens a airplanes category on my main window using SQL query.

    $kysely = "SELECT airplanes FROM table";

    Is it possible that the SELECT value comes from the link that I clicked? So I can make queries using only one script.

  2. #2
    SitePoint Member magistudios's Avatar
    Join Date
    Feb 2005
    Location
    Victoria, BC
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I would stay away from frames all together. They will give you problems down the road.

    Have you looked at OsCommerce? www.oscommerce.com
    It's a great open source e-commerce application that you can learn alot from.
    I built one of my sites (www.floormixes.com) using the OsCommerce application.
    Jay Neill
    Chief Strategy Officer
    Magi Studios
    www.magistudios.com

  3. #3
    SitePoint Member
    Join Date
    Feb 2005
    Posts
    21
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Nice site you have, but I'm still going to make it with frames.

    I know that frames suck, but I'm still going to use those.

    I specially need advice how I can get the value to my SQL SELECT query from the left_frames link url or something.

  4. #4
    SitePoint Member
    Join Date
    Feb 2005
    Posts
    21
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I just made up an idea for my problem.

    I wonder if it works.

    I just don't know the right syntax.

    <a href="<?php

    what if I make the database query here with the right SELECT title?
    because it opens the SQL query on the main window because i'm targetting it
    there

    ?>">Airplanes</a>

    and then I just copy paste the same thing and change only the SELECT title and URL description.

    Please give comments about my idea.

  5. #5
    SitePoint Member
    Join Date
    Feb 2005
    Posts
    21
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Please, can someone help my on my problem?

    I think that the idea I present is not going to work.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •