Inspiring

Answered

MYSQL sets

Forum|Forum|14 years ago
July 8, 2011
1 reply
422 views

Hi all,

I'm creating an admin area for a client and I have a field in the user table which is a set with the option of 'y' 'n'. If the user has 'y' then I want them to be able to see a couple of buttons that the user with 'n' cannot see. How can I go about this? I'm working in PHP by the way.

Cheers

Tom

Server side applications

This topic has been closed for replies.

Correct answer Ben M

Can we safely assume you have queried the necessary data into an array with your query?

If so, where you want this one particular button to go, you just need to use an if statement:

<?php if ($QueryArray['fieldx'] == "y" ) { echo "My Button"; } ?>

Community Expert

Correct answer

Community Expert

Can we safely assume you have queried the necessary data into an array with your query?

If so, where you want this one particular button to go, you just need to use an if statement:

<?php if ($QueryArray['fieldx'] == "y" ) { echo "My Button"; } ?>

sellador315Author

Inspiring

You can safely assume that yes.

It looks as if it will work perfectly. Cheers

T