mattm100

Well that mod_rewrite looks about as fun as being kicked in the unmentionables, I have been looking into it but the only problem is that my current hosting is a shared package and the hosting service does not allow direct access to the httpd.conf file. I have spoken to the support service and they say that I can do similar with htaccess file, I am not sure of this as I thought that could be used for redirecting pages and thats not what I am trying to do. mod_rewrite is enabled on the servers so I have been told that I can use scripts to do the job but again I am not sure.

You are dead right, the only difference between them (code wise) is that they each select different rooms. They use exactly the same code other than hard coded variable. The reason why I did it this way was to give structure to the website as I had no clue about mod_rewrite and didn't want the address ending up like 'room.php?roomid=bedroom?typeid=wardrobe?style=SantaFe'. Thank you for your help so far, you've cleared it up for me and I can get reworking it.

Ok, I got mixed up then, I thought that the links would be shown as room.php?roomid=bedroom in the browers rather than the other way around. So your saying it should be built around a single webpage? Would I then use if statements to include different php files for the different layout between the product page to the homepage? The attributes and the catagories are stored in tables. I will do more research on this in the morning.

The catalogue is for a small furniture shop, each room has multiple different sub categories and each have multiple attributes they can narrow down (style, colour, material, etc). Bedroom (10 sub categories) Garden (4) Living Room (5) DIning Room (4) Office (4) Using mod rewrite would it work the opposite way so that once clicking the bedroom link it would direct to products/bedroom/ ? I ask because as the their search goes deeper links like 'room.php?roomid=bedroom?typeid=wardrobe?style=SantaFe' are getting quite ugly. I'd like the pages to be shown like: products/bedroom/wardrobes or products/diningroom/diningtables then if they wanted to narrow down their search 'products/bedroom/wardrobes.php?style=santafe' would be fine. (That may not be correct as I have index files in the room folders.)

Hello Everyone, I am improving the catalogue website that I built not so long ago, trying to make it more dynamic and I have found many of the answers that I'm looking for from Google and PHPfreaks but would like to get some answers and opinions specific to me. I am having some issues with the navigation. Currently the navigation is not dynamic (the product pages are linked to mySQL tables, which lists them but it is nowhere near where I would like it to be) I am not using a txt file or a table specific to the navigation, I am thinking of using my exisiting 'Room' table (RoomID, RoomName) to list the links I want. Should I also add a column that lists the directory to the desired page, so I would use one variable for the link text then one for the actual link. My next question is when I am on a room page (/products/bedroom), how do I then add a sub menu on that page to list sub directorys without manually entering the RoomID like "SELECT * FROM furnituretype WHERE roomid = 1" (I have a seperate table for the type of furniture, for instance 1= Wardrobes, 2 = Bedsides, etc). I was thinking I could use a POST but again I am not sure that would be the right way to go. Am I able to take it from the directory that I am in? I have found 'basename($_SERVER['PHP_SELF']);' but that lists index.php. Any help would be great, I am not looking to be spoon fed (it may look that way) but some advice. Thanks,

Thank you for your help guys, got it sorted. I've been downloading a copy of database to print all along but it never clicked in my head to use that. Also the version of Publisher I had was 2002, so it never had the Catalog Merge option, now I have the 2010 version I seemed to have sorted it.

Sorry if I didn't explain myself very well, I will try and make it clearer. I have a website where I have a catalogue for my products which are all stored within a mysql database. I would like to be able to create a printed version of this catalogue, what I have attempted so far is creating a css stylesheet but that does not give me the desired layout I am looking for. I have also tried using Microsoft publisher but that cannot be an option to me now as my hosting does not allow remote access to the database. Is there a program out there that I could design my pages, for example 6 products per page, image, name, description and then I could populate the pages from my sql database?

Hi, I am having issues with finding an efficient way of displaying products from my database, in terms of a paper catalogue. I have a list of products in a sql database, what I am currently using is a separate webpage which I have made a very basic print stylesheet. I briefly tried publisher (as I read somewhere that you can populate your catalogue from a database) but I quickly discovered my provider does not allow remote access. So if anyone has any ideas that could point me in a better direction I am all ears. Thanks, Matt.