phpmyadmin Site Script/Queries

Discussion in 'Databases' started by mlao, Nov 27, 2008.

  1. #1
    I want free members on my site to send only 2 messages
    Is that possible :confused: I know I have to set and running a query on phpmyadmin... but I don't know the steps. I explore phpmyadmin and I click on QUERY tag.
    Now I see there also rules about running a query like
    Field: Sort: Show: Criteria: And: Or: Modify: Update and Modify
    I see also newflag on Field: rules.
    So if you tell me the steps I thing I can do it.;)
     
    mlao, Nov 27, 2008 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Yes, it is possible. But one can do only if he/she knows your application and database structure. In your application, there should be an option to set the number of messages a user can send. Try to figure out that point.
     
    mwasif, Nov 28, 2008 IP
  3. pondlife

    pondlife Peon

    Messages:
    898
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Sounds like you need to read up on SQL (structured query language) - when you've got the SQL you're after you can embed this into your web pages so that the query is run (checking for how many messages your users have entered) and you can give the users access to send a new message or not...

    Do you have a table/mechanism that is currently collecting your users activity? If you show us that we can help you build a script/query to check this :)

    Good luck!
     
    pondlife, Nov 28, 2008 IP
  4. cipals15

    cipals15 Well-Known Member

    Messages:
    1,085
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    100
    #4
    What are you current table fields? Is there a field that determine the number of messages?

    If none, you can add a column in your database table and use the value on that new column to limit the number of messages.
     
    cipals15, Nov 28, 2008 IP