This topic is locked

How to setup - public can view list / search / view of table but only

4/23/2007 1:28:03 PM
PHPRunner General questions
P
powerchuck author

I have a database that will share information on trails. I figured out that creating a new project with only the new table checked in step 3 keeps that table separate from the members section of my database.
I want anyone who comes to the website to be able to view this table without the hassle of logging in - even if its just clicking guest. It should be like an online store where all the wigets for sale are displayed along with their prices etc. And you only need to create an account if you are going to buy something.
I can't seem to figure out the logic.
NOTE: In the same database, is a members only section with registered users - I'd probably like add / edit of this public trails section to be done by just the registered users. I just don't want malicious persons adding , editing or deleting work that is meant to be freely shared.
Thanks for the help.

Sergey Kornilov admin 4/24/2007

Enable guest login and point your users directly to the List page. They will be logged in automatically.

P
powerchuck author 4/24/2007

That works, but then I can't login as an authorized user. I used the event script for thelogin page - OnLoad to redirect to the list view page. but now everyone is guest with no privleges. I was thinking I could put a hyperlink on the list view page back to a login screen but that doesn't do the trick.
i also tried creating an alternate table view of the database but I can't seem to get that to work....
Guests should go directly to the list view but to add / edit a login would be required and the authorized users should be the same ones as currently are in my database as members.
Also, before putting the redirect script in the login page wouldn't accept my prior login ? I selected the same _members table as my currently functioning database and the same _username & _password fields in security settings but I get invalid login?