MySQL Help

23,051 topics in this forum

1. Foreign Keys: Childless rows (NULL values in fk field)

   By doni49, January 9, 2016   

   • foreign key
   • 4 replies
   • 1.1k views
   • 
   • Muddy_Funster
   • January 15, 2016

2. mysq search criteria problem

   By neilfurry, January 13, 2016   

   • mysql
   • search
   • (and 1 more)

     Tagged with:

     • mysql
     • search
     • keyword
   • 4 replies
   • 1.2k views
   • 
   • requinix
   • January 13, 2016

3. WEEKLY QUERY 1 2

   By benanamen, January 7, 2016   

   • mysql
   • 38 replies
   • 3.8k views
   • 
   • benanamen
   • January 12, 2016

4. Returning Multiple Copies of Same Entry

   By SteveCatbert, January 10, 2016
   • 4 replies
   • 781 views
   • 
   • Barand
   • January 12, 2016

5. Getting only last date of transaction with join

   By I-AM-OBODO, January 11, 2016   

   • pdo
   • php
   • (and 2 more)

     Tagged with:

     • pdo
     • php
     • mysql
     • join
   • 4 replies
   • 2.2k views
   • 
   • I-AM-OBODO
   • January 11, 2016

6. Multiple Queries Help

   By SteveCatbert, January 5, 2016
   • 8 replies
   • 873 views
   • 
   • SteveCatbert
   • January 10, 2016

7. Trouble with foreign keys

   By doni49, January 2, 2016
   • 3 replies
   • 915 views
   • 
   • doni49
   • January 5, 2016

8. Best way to design these tables and query them?

   By GuitarGod, January 3, 2016
   • 4 replies
   • 1k views
   • 
   • Barand
   • January 4, 2016

9. Insert using prepared procedure puts bad data in the table

   By doni49, January 2, 2016
   • 7 replies
   • 1.2k views
   • 
   • doni49
   • January 3, 2016

10. MySQL error connecting to database

    By foodie, January 2, 2016
    • 5 replies
    • 1.4k views
    • 
    • foodie
    • January 2, 2016

11. Query help - looking for members of two different groups

    By simonp, January 2, 2016
    • 7 replies
    • 1.9k views
    • 
    • simonp
    • January 2, 2016

12. Reading old phpfreaks threads -- what does this code do (from Barand's reply)?

    By doni49, January 2, 2016
    • 2 replies
    • 767 views
    • 
    • benanamen
    • January 2, 2016

13. mutliple conditions for same join for same column 1 2

    By Destramic, December 28, 2015
    • 29 replies
    • 3.3k views
    • 
    • Destramic
    • December 31, 2015

14. cant update table from another table

    By manhattes, December 30, 2015   

    • php
    • sql
    • (and 1 more)

      Tagged with:

      • php
      • sql
      • mysql
    • 6 replies
    • 1.4k views
    • 
    • manhattes
    • December 30, 2015

15. Help understanding why this Mysql Query is badly designed.

    By blmg2009, December 21, 2015   

    • mysql
    • query
    • 5 replies
    • 1.5k views
    • 
    • Muddy_Funster
    • December 29, 2015

16. (MYSQL) Table relationship and Foreign key

    By hoangthi, December 29, 2015
    • 3 replies
    • 928 views
    • 
    • hoangthi
    • December 29, 2015

17. Creating relationship tables from JSON data....

    By doni49, December 27, 2015
    • 3 replies
    • 974 views
    • 
    • doni49
    • December 29, 2015

18. Question about deleting where no matching record to join

    By sKunKbad, December 28, 2015
    • 2 replies
    • 805 views
    • 
    • Jacques1
    • December 28, 2015

19. retrieve last 3 months data and display in PHP

    By ianhaney, December 24, 2015
    • 2 replies
    • 766 views
    • 
    • ianhaney
    • December 24, 2015

20. Column 'description' cannot be part of FULLTEXT index

    By Destramic, December 23, 2015   

    • innodb
    • mariadb 10
    • 3 replies
    • 3.5k views
    • 
    • Destramic
    • December 23, 2015

21. INSERT... ON DUPLICATE KEY UPDATE issue

    By thara, December 20, 2015   

    • mysql
    • php
    • 11 replies
    • 2.6k views
    • 
    • Psycho
    • December 21, 2015

22. Get Result from Stored procedure MySql PHP in HTML Table

    By sumeetp, December 21, 2015   

    • sql
    • stored-procedure
    • (and 1 more)

      Tagged with:

      • sql
      • stored-procedure
      • php
    • 0 replies
    • 1k views
    • 
    • sumeetp
    • December 21, 2015

23. I can't combine these two selects

    By kenw232, December 20, 2015
    • 3 replies
    • 746 views
    • 
    • Barand
    • December 20, 2015

24. Can I sort results manually after a fetch?

    By kenw232, December 20, 2015
    • 1 reply
    • 705 views
    • 
    • Barand
    • December 20, 2015

25. Date Wrong Format, Wrong Column Type

    By benanamen, December 18, 2015   

    • date
    • 3 replies
    • 1.6k views
    • 
    • Jacques1
    • December 18, 2015