close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Create a secure simple online directory

Thread began 10/04/2012 11:23 am by thehalpeen319342 | Last modified 10/18/2012 11:50 am by thehalpeen319342 | 2763 views | 21 replies

Jason ByrnesWebAssist

  I have two tables - users/administrators and members/customers.  

you should not use 2 tables for this. you should use only one table and set up user levels

using 2 tables will create unneeded confusion, and complexity to your project and lead to unwanted bugs.

  Should the delete checkbox be ignored as
well – it’s not too clear?  

  Should the delete
checkbox be selected as well?  

When creating the Administrative pages, the checkbox option to include the delete button should be checked so that the admin can delete users if needed.

when creating the public pages, the checkbox to include the delete button should not be checked, you don't want users to be able to delete records, right?

  But there is a security issue. If I login as a member –I
should have access only to the profile page. But I have
access to admin_results, admin_insert – these are all pages
with restricted access to admin login and not members

this is the sort of issue that will happen as a result of using 2 tables. this is exactly why i suggested at the very beginning that you don't use 2 tables and only use 1.

most likely the 2 tables use the same column name for the user group column or the ID column which will cause the session being saved on login to be the same, thereby making it impossible for the system to determine if a user or admin has logged in. This is why using 2 tables is a bad idea.

instead, use 1 table, and use user level authentication which uses the UserGroup column to determine which user type is logged in.

  However if the result pages were to ‘show all’,
wouldn’t it include the users/staff as well in the results
page – this is not what I want – I only want to see

you can set the results recordset to include a where clause to return only members/customers based on the UserGroup column value.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...