Database check if exist

ivotrompert · #1 (**permalink**) 08-19-2007, 01:09 PM

I have the following problem. I have a database with the following tables users and roles. I want to check if the role is in use by a user if this is true than the role can not be removed and this must be visual to the user by the words "In gebruik" (dutch for "in use"). My layout of my tables is this:

The users table:
Id
username
password
real_name
role ---------> this is the Id of the role table
e-mail

The roles table:
Id
name
access

I have created the following files for the database communication:

users.php

PHP Code:


			
class Users extends Zend_Db_Table_Abstract

{

    protected $_name = 'users';

    protected $_primary = 'id';

}

roles.php

PHP Code:


			
class Roles extends Zend_Db_Table_Abstract

{

    protected $_name = 'roles';

    protected $_primary = 'id';

}

I hope that someone can help me because I'm really stuck here.

Thank you,

Ivo

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode