Title: Database Table  with sql
Last modified: August 31, 2016

---

# Database Table with sql

 *  [shadowgr](https://wordpress.org/support/users/shadowgr/)
 * (@shadowgr)
 * [9 years, 12 months ago](https://wordpress.org/support/topic/database-table-with-sql/)
 * Hello
 * i want to make a table with database for (football) tips i know how to do it 
   only with sql but i need and a friendly enviroment for the aurthors to edit the
   table in my site .
 * i want also to display all data from table in the main page , but in an other
   page i want to display Bets Win Lose Void something like that
 *     ```
       SELECT count(id) AS Tips,count(WinLoss) As win
       FROM table
       WHERE WinLoss="yes";
       ```
   
 * here is a photo to explain:[IMG](http://prntscr.com/aqoaz2)

The topic ‘Database Table with sql’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)
 * [table](https://wordpress.org/support/topic-tag/table/)
 * [wpdatatable](https://wordpress.org/support/topic-tag/wpdatatable/)

 * 0 replies
 * 1 participant
 * Last reply from: [shadowgr](https://wordpress.org/support/users/shadowgr/)
 * Last activity: [9 years, 12 months ago](https://wordpress.org/support/topic/database-table-with-sql/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics