MySQL Help

23,012 topics in this forum

1. Grouping / Joining / Ordering

   By ElmoTheClown, January 28, 2016   

   • mysql
   • order by
   • (and 1 more)

     Tagged with:

     • mysql
     • order by
     • hierarchical
   • 3 replies
   • 1.3k views
   • 
   • ElmoTheClown
   • February 9, 2016

2. MySQL lists generated in PHP

   By EricOnAdventure, June 14, 2016
   • 14 replies
   • 1.3k views
   • 
   • Zane
   • June 16, 2016

3. Problem using GROUP_CONCAT

   By Shadowing, April 9, 2013
   • 8 replies
   • 1.3k views
   • 
   • Shadowing
   • April 9, 2013

4. mySQL query: try for one minute.

   By ChenXiu, September 8, 2021
   • 7 replies
   • 1.3k views
   • 
   • Barand
   • September 9, 2021

5. Perfect mySQL one liner?

   By ChenXiu, August 28, 2021
   • 6 replies
   • 1.3k views
   • 
   • Barand
   • August 29, 2021

6. bindParam not working with prepare($sql)

   By kalster, January 3, 2015   

   • bindparam pdo
   • 9 replies
   • 1.3k views
   • 
   • mac_gyver
   • January 3, 2015

7. changing the database for a different country.

   By ajoo, January 9, 2018   

   • database
   • dynamic databases
   • 5 replies
   • 1.3k views
   • 
   • requinix
   • January 9, 2018

8. Is there any downsides to using this method to randomly select a user id from a table?

   By imgrooot, April 11, 2017   

   • user
   • id
   • (and 3 more)

     Tagged with:

     • user
     • id
     • random
     • select
     • query
   • 14 replies
   • 1.3k views
   • 
   • imgrooot
   • April 11, 2017

9. PHP or MYSQL Converting Empty String to Zero

   By Ravenman7, March 5, 2014
   • 2 replies
   • 1.3k views
   • 
   • Ravenman7
   • March 13, 2014

10. Datatypes for different fields in a database

    By erikla, June 29, 2014   

    • datatypes
    • 4 replies
    • 1.3k views
    • 
    • erikla
    • June 30, 2014

11. Limit in query not working?

    By rocky48, April 27, 2015
    • 4 replies
    • 1.3k views
    • 
    • Psycho
    • May 13, 2015

12. Undefined Index

    By shackwm60, January 14, 2015
    • 5 replies
    • 1.3k views
    • 
    • Jacques1
    • January 15, 2015

13. create table; datetime default value current_timestamp +

    By fatkatie, August 24, 2017   

    • mysql
    • 5 replies
    • 1.3k views
    • 
    • Jacques1
    • August 27, 2017

14. User table with different access permissions

    By clint, October 7, 2010
    • 2 replies
    • 1.3k views
    • 
    • ignace
    • October 7, 2010

15. newbie getting unexpected $end

    By sdgsdghshhg, November 15, 2017
    • 8 replies
    • 1.3k views
    • 
    • sdgsdghshhg
    • November 16, 2017

16. Best of 2 Tables? Most Efficient.

    By ChenXiu, July 4, 2021
    • 8 replies
    • 1.3k views
    • 
    • kicken
    • July 5, 2021

17. joining 3 tables mysql

    By ardhix, April 2, 2013   

    • inner join
    • join
    • (and 3 more)

      Tagged with:

      • inner join
      • join
      • mysql
      • php
      • select
    • 3 replies
    • 1.3k views
    • 
    • lilmer
    • April 6, 2013

18. Retrieve first table id from left joined tables

    By lasha, March 24, 2014   

    • left join
    • retrieve
    • (and 3 more)

      Tagged with:

      • left join
      • retrieve
      • table
      • id
      • join
    • 2 replies
    • 1.3k views
    • 
    • lasha
    • March 24, 2014

19. GROUP BY makes my query fail

    By fife, April 9, 2013   

    • mssql
    • groupby
    • (and 1 more)

      Tagged with:

      • mssql
      • groupby
      • sql
    • 9 replies
    • 1.3k views
    • 
    • fife
    • April 10, 2013

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

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

21. Dynamic displaying of 'tiles'

    By DaveyK, May 27, 2013
    • 8 replies
    • 1.3k views
    • 
    • DaveyK
    • May 27, 2013

22. Altering Existing Table With Data

    By JipThePeople, July 7, 2014   

    • mysql
    • 2 replies
    • 1.3k views
    • 
    • JipThePeople
    • July 7, 2014

23. Simple averageing problem

    By ajoo, November 22, 2013   

    • ajoo
    • average of data in groups of
    • 9 replies
    • 1.3k views
    • 
    • Barand
    • November 22, 2013

24. Get All Records From Table one Joining other table

    By lilmer, July 6, 2016   

    • sql
    • join
    • 8 replies
    • 1.3k views
    • 
    • Barand
    • July 6, 2016

25. mysql geoip

    By Destramic, January 31, 2015
    • 6 replies
    • 1.2k views
    • 
    • Destramic
    • February 5, 2015