MySQL Help

23,051 topics in this forum

1. Pivot Table or Cross Tab in PHP using MYSQLI for attendance

   By Zinn, June 6, 2022   

   • php
   • mysqli
   • (and 3 more)

     Tagged with:

     • php
     • mysqli
     • pivot table
     • table
     • date
   • 15 replies
   • 2.7k views
   • 
   • Zinn
   • June 9, 2022

2. Error in a PHP MySQL CMS.

   By LeonLatex, June 8, 2022
   • 13 replies
   • 1.7k views
   • 
   • LeonLatex
   • June 9, 2022

3. MySQL update query to automatically Deduct quantity sold from quantity in the stock table 1 2

   By thara, June 4, 2022   

   • mysql
   • sql
   • 25 replies
   • 3.5k views
   • 
   • thara
   • June 8, 2022

4. Which is faster, MySql INNER JOIN or PHP Loop?

   By SLSCoder, May 19, 2022
   • 8 replies
   • 2.6k views
   • 
   • SLSCoder
   • June 7, 2022

5. How can I make this more efficient?

   By SLSCoder, June 6, 2022
   • 0 replies
   • 591 views
   • 
   • SLSCoder
   • June 6, 2022

6. Can't CREATE DATABASE and more problems with Laragon and MySQL

   By LeonLatex, June 5, 2022
   • 10 replies
   • 5k views
   • 
   • LeonLatex
   • June 5, 2022

7. Laragon 8.0.29 set password on root

   By LeonLatex, June 2, 2022
   • 7 replies
   • 3k views
   • 
   • LeonLatex
   • June 2, 2022

8. Download MySQL 8.0.29

   By LeonLatex, May 31, 2022
   • 5 replies
   • 1.9k views
   • 
   • LeonLatex
   • June 1, 2022

9. Getting unique rows

   By ginerjm, May 25, 2022
   • 14 replies
   • 1.3k views
   • 
   • Barand
   • May 26, 2022

10. Another database structure

    By phppup, May 24, 2022
    • 6 replies
    • 1.5k views
    • 
    • Barand
    • May 24, 2022

11. Understanding mySQL dates and times.

    By TapeGun007, May 22, 2022
    • 5 replies
    • 832 views
    • 
    • TapeGun007
    • May 23, 2022

12. Setting up foreign key

    By phppup, May 22, 2022
    • 5 replies
    • 923 views
    • 
    • Barand
    • May 22, 2022

13. Problem comparing dates, but not getting results.

    By TapeGun007, May 18, 2022
    • 9 replies
    • 1k views
    • 
    • Barand
    • May 22, 2022

14. Structure MySQL database with different media types such as movies, music and games

    By Guldstrand, May 22, 2022
    • 1 reply
    • 925 views
    • 
    • requinix
    • May 22, 2022

15. Database reference material

    By phppup, May 11, 2022
    • 5 replies
    • 1.3k views
    • 
    • phppup
    • May 11, 2022

16. database structure

    By phppup, May 10, 2022
    • 5 replies
    • 1.1k views
    • 
    • Barand
    • May 10, 2022

17. working with time/date

    By phppup, May 6, 2022
    • 3 replies
    • 787 views
    • 
    • Barand
    • May 9, 2022

18. selecting distinct items and listing vehicles last cleaned based on criteria

    By PatrickO, April 30, 2022
    • 16 replies
    • 1.2k views
    • 
    • Barand
    • May 2, 2022

19. I want to use PDO functions instead of mysql_* functions? (e.g. mysql_query(), mysql_connect() or mysql_real_escape_string())? So what should I change about this code so it's PDO?

    By Bramdon3000, April 28, 2022
    • 2 replies
    • 1k views
    • 
    • Barand
    • April 28, 2022

20. Can't delete duplicate rows in a table

    By stevepatd, April 15, 2022
    • 5 replies
    • 1.6k views
    • 
    • stevepatd
    • April 15, 2022

21. Query problem.

    By ginerjm, April 14, 2022   

    • mysql
    • 7 replies
    • 1.4k views
    • 
    • ginerjm
    • April 15, 2022

22. Using bitwise operations in the WHERE clause

    By NotionCommotion, April 2, 2022
    • 4 replies
    • 1.9k views
    • 
    • NotionCommotion
    • April 4, 2022

23. try to get active and non active from two different date rows

    By Tanja, April 2, 2022
    • 11 replies
    • 1.1k views
    • 
    • Barand
    • April 3, 2022

24. Ascertain access

    By KillGorack, March 12, 2022   

    • sql
    • boolean
    • 7 replies
    • 2.2k views
    • 
    • gizmola
    • March 14, 2022

25. When asrray value is 0 use last value not 0

    By Paulqvz, March 3, 2022
    • 1 reply
    • 692 views
    • 
    • gizmola
    • March 6, 2022