MySQL Help

22,907 topics in this forum

1. How do you list two columns but not show duplicates from first column?

   By Plugnz13, June 21
   • 3 replies
   • 265 views
   • 
   • Plugnz13
   • June 24

2. Error insertuserquery

   By Pikatucy, June 16
   • 18 replies
   • 278 views
   • 
   • Pikatucy
   • June 19

3. Objects, Classes, Variables, Libraries and Functions

   By LeonLatex, June 9
   • 8 replies
   • 233 views
   • 
   • mac_gyver
   • June 10

4. Error in a PHP MySQL CMS.

   By LeonLatex, June 8
   • 13 replies
   • 295 views
   • 
   • LeonLatex
   • June 9

5. How can I make this more efficient?

   By SLSCoder, June 6
   • 0 replies
   • 176 views
   • 
   • SLSCoder
   • June 6

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

   By Zinn, June 6   

   • php
   • mysqli
   • (and 3 more)

     Tagged with:

     • php
     • mysqli
     • pivot table
     • table
     • date
   • 15 replies
   • 475 views
   • 
   • Zinn
   • June 9

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

   By LeonLatex, June 5
   • 10 replies
   • 210 views
   • 
   • LeonLatex
   • June 5

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

   By thara, June 4   

   • mysql
   • sql
   • 25 replies
   • 407 views
   • 
   • thara
   • June 8

9. Laragon 8.0.29 set password on root

   By LeonLatex, June 2
   • 7 replies
   • 171 views
   • 
   • LeonLatex
   • June 2

10. Foreign key NOT working

    By phppup, June 1
    • 9 replies
    • 281 views
    • 
    • phppup
    • June 12

11. Download MySQL 8.0.29

    By LeonLatex, May 31
    • 5 replies
    • 315 views
    • 
    • LeonLatex
    • June 1

12. Getting unique rows

    By ginerjm, May 25
    • 14 replies
    • 264 views
    • 
    • Barand
    • May 26

13. Another database structure

    By phppup, May 24
    • 6 replies
    • 174 views
    • 
    • Barand
    • May 24

14. Setting up foreign key

    By phppup, May 22
    • 5 replies
    • 190 views
    • 
    • Barand
    • May 22

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

    By Guldstrand, May 22
    • 1 reply
    • 124 views
    • 
    • requinix
    • May 22

16. Understanding mySQL dates and times.

    By TapeGun007, May 22
    • 5 replies
    • 210 views
    • 
    • TapeGun007
    • May 23

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

    By SLSCoder, May 19
    • 8 replies
    • 305 views
    • 
    • SLSCoder
    • June 7

18. Problem comparing dates, but not getting results.

    By TapeGun007, May 18
    • 9 replies
    • 244 views
    • 
    • Barand
    • May 22

19. Database reference material

    By phppup, May 11
    • 5 replies
    • 209 views
    • 
    • phppup
    • May 11

20. database structure

    By phppup, May 10
    • 5 replies
    • 190 views
    • 
    • Barand
    • May 10

21. working with time/date

    By phppup, May 6
    • 3 replies
    • 159 views
    • 
    • Barand
    • May 9

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

    By PatrickO, April 30
    • 16 replies
    • 310 views
    • 
    • Barand
    • May 2

23. 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
    • 2 replies
    • 142 views
    • 
    • Barand
    • April 28

24. Can't delete duplicate rows in a table

    By stevepatd, April 15
    • 5 replies
    • 190 views
    • 
    • stevepatd
    • April 15

25. Query problem.

    By ginerjm, April 14   

    • mysql
    • 7 replies
    • 239 views
    • 
    • ginerjm
    • April 15