I'm an old fart trying to get into an area that is exciting and new. I appologise for not understanding the code and I am trying to learn. I have a program that does that for me. However I am trying to tweek what I have.

I have two sites using the same database. The main site has the tournament entry default to "Not Aproved" and I would like it to not show up on the list until admin approves it. On the admin site they can select "Not Approved;;Approved" and when it is approved I would like that file to appear in the main list view.

I think it is something like:
SELECT YouthTournamentEntry.Approval, from YouthTournamentEntry_table where YouthTournamentEntry.Approval = 'approved';

However I don't know how to put it into the Query or if it is in fact correct.

The code is below and I have a sample site at Your Page Title


The code for the viewing is:
// mm: build the query based on current member's permissions
if($perm[2]==3){ // view all
$x->Query = "select YouthTournamentEntry.youth_id as 'ID', YouthTournamentEntry.Date as 'Date', YouthTournamentEntry.Age as 'Age', YouthTournamentEntry.Class as 'Class', YouthTournamentEntry.Location as 'Location', YouthTournamentEntry.Website as 'Website', YouthTournamentEntry.Tournament_Name as 'Tournament Name', YouthTournamentEntry.Approval as 'Approval', YouthTournamentEntry.Format as 'Format', CONCAT('$', YouthTournamentEntry.Fee) as 'Fee', YouthTournamentEntry.Contact as 'Contact', YouthTournamentEntry.Email as 'Email', YouthTournamentEntry.Telephone as 'Telephone' from YouthTournamentEntry, membership_userrecords where YouthTournamentEntry.youth_id=membership_userrecor ds.pkValue and membership_userrecords.tableName='YouthTournamentE ntry' and membership_userrecords.memberID='".getLoggedMember ID()."'";


Thanks