mat123slade Posted November 25, 2004 Posted November 25, 2004 Hello, I have searched the contributions without any luck... I am looking for a way of showing information and pages to wholesalers (used with seperate price per customer), that only they will see, such as for example information about transport, information about futur products and other specific information. It doesn't have to be linked with seperate price per customer, idealy I would like to just go to my admin and select customers that will see this info. Ideally basicaly chose if a customer can see or not an infobox. Thanx.
gscreations Posted November 25, 2004 Posted November 25, 2004 Quite a lot to do here Briefly: Add a column to your customers database table simple true/false option then add into your admin/customers a check box/radio button allowing you to select which customer you want to give this option to. Then for each info box you want them to see add a simple if statement looking at the newly added column in database, if true show box if not dont show, etc.. Now if your a good enough php coder this will take a couple hours to sort out. If not contact me with more details on excatly what your trying to do and I'll let you know how much it will cost. recent references and sites are available at request.
mat123slade Posted November 25, 2004 Author Posted November 25, 2004 Add a column to your customers database table simple true/false optionthen add into your admin/customers a check box/radio button allowing you to select which customer you want to give this option to. Then for each info box you want them to see add a simple if statement looking at the newly added column in database, if true show box if not dont show, etc.. Thanx ever so much for your help, I shall give it a go during the night. All the Best.
mat123slade Posted November 26, 2004 Author Posted November 26, 2004 I've done everything you indicated, and it seams to be ok, but I am struggling with the variable from which the data is coming from, here is my code... I'm sure it's simple to correct, do you have an idea of the variable to use, or the error in this code please? if(mysql_result(mysql_query("SELECT `customers_shop` FROM `customers` WHERE `customers_shop`=".$customers_shop." LIMIT 1"),0) == 1) { echo 'Hello Retailer'; } Customers_shop is the name of the field I have added to the customers database. It is the same system as for the newsletter (0 or 1) where 1 will show retailers text and 0 will show public text with an 'else'. Thanx again for the help.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.