i need help

chill84

ok basically what i want to do is build a list of members with email address and phone numbers. i want all the executive members available for viewing by anonymous users. however every one else on the list can only be viewed by registered users. also on the executive list i dont want their phone numbers listed unless viewed by a registered user. how hard is this to do? how should i do this? any help would be great

here is an example of what i want: http://www.iotamu.ca/search.php?search=3&Submit=Show+All

Roger_Ramjet

Registered users must log in, right? Then store a session variable that you use in your query to match a parameter in your table. If it is present then all records are returned, if absent then only the subset is matched and returned.

chill84

the problem is what you just said is greek to me. i think i might be in over my head. i have phpNuke installed is there anyway to do this with that.

Roger_Ramjet

This link will explain sessions for you: http://www.sitepoint.com/print/users-php-sessions-mysql
and gives the code for implementing sign-up and log-in.

However, it sounds as if even this may be beyond you. How exactly are you registering users, and how are you identifying them?

No matter, once you have identified a registered user then run this bit of code

session_start();
//starts a session
$_SESSION['reg'] = 1;
//stores a 1 in a variable called reg in an array called $_SESSION[]

See the manual for info on $_SESSION http://uk.php.net/en/language.variables.predefined

Then when you come to query the db you use an if clause to determine which query to run

if (isset($_SESSION['reg']) {
// run full query
}
else {
//run restricted query
}

Display accordingly

chill84

This is what i came up with but it is giving me an error

if (isset($_SESSION['reg']) {
while ($row = mysql_fetch_array($result)) {
echo '<p>' . $row['ID'] . '
' . $row['userid'] . '
' . $row['password'] . '
' . $row['fullname'] . '
' . $row['email'] . '
</p>';
}
}
else {
while ($row = mysql_fetch_array($result)) {
echo '<p>' . $row['ID'] . '
' . $row['userid'] . '
' . $row[''] . '
' . $row[''] . '
' . $row['email'] . '
</p>';
}
}

Roger_Ramjet

And the error is???

(always include the full error message when posting here)

chill84

im sorry it said the error was on line 37 which would be after the { on the line that has the if statement. however i did think of a way to get it to work with out this i just created to scripts one for the anonymous users and one to put on the page for the users and just made the users page password protected with that tutorial you showed me. thanks.