Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Mar 2006
    Thanked 0 Times in 0 Posts

    Showing Status Of Members

    Hi all,

    Am very new to PHP so please bear with me... I have a MySQL database which has members in it, I have a column called 'MemberApproved', which has these values A, D, H, N, P and R... Which stand for:

    A = Approved
    D = Deleted
    H = On Hold
    P = Pending
    N = (UNSURE)
    R = Rejected

    The 'N' I am very confused about as I didn't design the DB... Anyway I want to create a PHP page which looks like the attached image, and from there I want to make the 'Amount' and also the 'Approval' a link so you can click on that and it shows all the members on a nother page which are Approved etc. In that list I would like to show FirstName, LastName, State, loginDateTime. I would also on that page like to have an 'edit' link and a 'delete' link. If the user clicks the edit link would be simple just a drop down list with the Approved, Deleted, On Hold, Pending, Rejected and that can be saved and updated...

    As I said I am very new to PHP so any help would be greatly appreciated! Thanks all in advance!
    Attached Thumbnails Attached Thumbnails Showing Status Of Members-picture-1.gif  

  • #2
    Regular Coder the-dream's Avatar
    Join Date
    Mar 2007
    Northamptonshire, UK
    Thanked 4 Times in 4 Posts


    if your using dreamweaver then you can use the mysql connect then login scripts built in then use accses level for the login in dreamweaver. if you don't have dreamweaver you can get a trial of it fo 30 days at www.adobe.com!


    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts