If MySQL didnt have any result

Discussion in 'Plugin Development' started by ensirius, Dec 24, 2011.

Thread Status:
Not open for further replies.
  1. Offline

    ensirius

    If MySQL query didnt have any result,how i can say to player something?

    PHP:
     public void take(Player pl) {
             
    String player pl.getName();
             
    String query "SELECT id,item FROM " this.tableName " WHERE player='" player "'";
            try {
               if (
    this.connection.isClosed()) {
                 
    connect();
              }
               
    ResultSet rs this.statement.executeQuery(query);
               
    int queryCount getTotalTakeQuery(pl);
               
    int queryCheck 0;
               while (
    rs.next()) {
     
  2. Offline

    KabOOm 356

    Code:java
    1. if(rs.first()) {
    2. // Results returned
    3. }
    4. else {
    5. // No results returned
    6. }
     
Thread Status:
Not open for further replies.

Share This Page