MySQL Help

23,007 topics in this forum

1. Unknown column 'Bacon' in 'field list'

   By jahicki, September 29, 2020
   • 1 reply
   • 1.4k views
   • 
   • Barand
   • September 29, 2020

2. Creating a view that shows a specific users activity for the past week that is then able to be graphed

   By mongoose00318, September 21, 2020
   • 3 replies
   • 753 views
   • 
   • mongoose00318
   • September 21, 2020

3. bookmark table design

   By jodunno, May 9, 2020
   • 12 replies
   • 3.1k views
   • 
   • jodunno
   • September 19, 2020

4. Change table style when mysql result matches

   By Jurtz, September 18, 2020
   • 6 replies
   • 947 views
   • 
   • requinix
   • September 18, 2020

5. Having an issue with LIMIT when trying to select most recent record

   By mongoose00318, September 14, 2020
   • 5 replies
   • 1.3k views
   • 
   • mongoose00318
   • September 15, 2020

6. Distinct values with Joins

   By bbram, September 13, 2020
   • 1 reply
   • 776 views
   • 
   • Barand
   • September 13, 2020

7. Querying Multiple Subtypes

   By SaranacLake, September 12, 2020
   • 5 replies
   • 1.4k views
   • 
   • SaranacLake
   • September 12, 2020

8. What is the best table structure for use with PHP?

   By bakertaylor28, September 4, 2020   

   • table
   • database php
   • (and 3 more)

     Tagged with:

     • table
     • database php
     • php
     • mysql
     • sql
   • 10 replies
   • 2.2k views
   • 
   • maxxd
   • September 10, 2020

9. Using ORDER BY and WHERE in the same SQL statement

   By Eltik, September 9, 2020
   • 2 replies
   • 822 views
   • 
   • Eltik
   • September 9, 2020

10. Can't get $_POST information

    By JohnS1175, September 7, 2020   

    • php
    • mysql
    • (and 1 more)

      Tagged with:

      • php
      • mysql
      • pdo
    • 1 reply
    • 995 views
    • 
    • requinix
    • September 7, 2020

11. Setting up a Lookup Table

    By SaranacLake, August 9, 2020
    • 8 replies
    • 2k views
    • 
    • Barand
    • September 4, 2020

12. (Solved) PDO Mysql error

    By gmc1103, September 1, 2020
    • 0 replies
    • 975 views
    • 
    • gmc1103
    • September 1, 2020

13. MySQL Backup using PDO

    By mongoose00318, August 26, 2020
    • 6 replies
    • 1.4k views
    • 
    • kicken
    • September 1, 2020

14. Select MAX(date) from a group of records?

    By mongoose00318, August 25, 2020
    • 5 replies
    • 6.5k views
    • 
    • mongoose00318
    • August 26, 2020

15. MySQL ordering when reading in a table

    By KenHorse, August 21, 2020
    • 1 reply
    • 688 views
    • 
    • KenHorse
    • August 21, 2020

16. Evidently can't create a view with a subquery in MySQL 5.6...

    By Jim R, August 19, 2020
    • 6 replies
    • 901 views
    • 
    • Jim R
    • August 20, 2020

17. SQL Query Problem

    By larry29936, August 14, 2020   

    • query mysql
    • ip
    • 3 replies
    • 1.1k views
    • 
    • Barand
    • August 14, 2020

18. Zero or One Relationship

    By SaranacLake, August 9, 2020
    • 3 replies
    • 1.3k views
    • 
    • SaranacLake
    • August 10, 2020

19. convert unixtime to date

    By 684425, August 6, 2020
    • 3 replies
    • 883 views
    • 
    • Barand
    • August 6, 2020

20. Simpe Price Code

    By testtest, August 4, 2020
    • 1 reply
    • 744 views
    • 
    • Barand
    • August 4, 2020

21. Joining two tables as sums with individual records

    By 684425, August 1, 2020
    • 9 replies
    • 1.4k views
    • 
    • 684425
    • August 2, 2020

22. Where am I most likely to get into trouble?

    By SaranacLake, July 30, 2020
    • 2 replies
    • 1.1k views
    • 
    • SaranacLake
    • July 30, 2020

23. Clarification on FKs and Indexes

    By SaranacLake, July 29, 2020
    • 4 replies
    • 905 views
    • 
    • SaranacLake
    • July 30, 2020

24. Database creation help

    By 684425, July 27, 2020
    • 7 replies
    • 1.7k views
    • 
    • 684425
    • July 28, 2020

25. Query for One To Many Relation In The Same Table

    By JDevOnline, May 27, 2020
    • 21 replies
    • 2k views
    • 
    • Barand
    • July 26, 2020