28 Answered Questions

[SOLVED] How can I prevent SQL injection in PHP?

13 Answered Questions

[SOLVED] Why shouldn't I use mysql_* functions in PHP?

  • 2012-10-12 13:18:39
  • Madara Uchiha
  • 168402 View
  • 2057 Score
  • 13 Answer
  • Tags:   php mysql database

33 Answered Questions

11 Answered Questions

[SOLVED] When to use single quotes, double quotes, and back ticks in MySQL

  • 2012-07-04 01:53:36
  • Nate
  • 118364 View
  • 438 Score
  • 11 Answer
  • Tags:   mysql sql quotes

14 Answered Questions

[SOLVED] UTF-8 all the way through

5 Answered Questions

[SOLVED] SQL injection that gets around mysql_real_escape_string()

5 Answered Questions

[SOLVED] Can I mix MySQL APIs in PHP?

1 Answered Questions

[SOLVED] Syntax error due to using a reserved word as a table or column name in MySQL

8 Answered Questions

[SOLVED] MySQL pivot table

  • 2011-10-06 13:20:14
  • peku
  • 206912 View
  • 215 Score
  • 8 Answer
  • Tags:   mysql pivot

29 Answered Questions

[SOLVED] SQL select only rows with max value on a column

3 Answered Questions

18 Answered Questions

[SOLVED] Retrieving the last record in each group

1 Answered Questions

[SOLVED] My PDO Statement doesn't work

  • 2015-09-18 09:20:28
  • Rifthy
  • 3088 View
  • 17 Score
  • 1 Answer
  • Tags:   php mysql pdo

12 Answered Questions

[SOLVED] Connect Java to a MySQL database

  • 2010-05-15 07:39:21
  • abson
  • 390873 View
  • 245 Score
  • 12 Answer
  • Tags:   java mysql jdbc

14 Answered Questions

[SOLVED] MySQL Error 1093 - Can't specify target table for update in FROM clause

13 Answered Questions

[SOLVED] How to do a FULL OUTER JOIN in MySQL?

3 Answered Questions

[SOLVED] check if row exists with mysql

  • 2014-03-07 14:33:02
  • user2882684
  • 60511 View
  • 17 Score
  • 3 Answer
  • Tags:   php mysql

13 Answered Questions

[SOLVED] Using LIMIT within GROUP BY to get N results per group?

1 Answered Questions

[SOLVED] MySQL pivot row into dynamic number of columns

  • 2012-08-17 11:06:46
  • FeeJai
  • 63894 View
  • 48 Score
  • 1 Answer
  • Tags:   mysql sql pivot

10 Answered Questions

[SOLVED] INNER JOIN ON vs WHERE clause

1 Answered Questions

13 Answered Questions

[SOLVED] mysqli or PDO - what are the pros and cons?

25 Answered Questions

[SOLVED] com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

  • 2010-06-06 05:49:10
  • Josh K
  • 343607 View
  • 127 Score
  • 25 Answer
  • Tags:   java mysql jdbc

9 Answered Questions

[SOLVED] How to do a regular expression replace in MySQL?

20 Answered Questions

[SOLVED] ROW_NUMBER() in MySQL

6 Answered Questions

[SOLVED] How can an SQL query return data from multiple tables

  • 2012-09-18 11:11:39
  • Fluffeh
  • 657801 View
  • 362 Score
  • 6 Answer
  • Tags:   mysql sql select

13 Answered Questions

[SOLVED] Project Links do not work on Wamp Server

8 Answered Questions

[SOLVED] Get top n records for each group of grouped results

17 Answered Questions

3 Answered Questions

[SOLVED] What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?

  • 2011-04-18 17:15:24
  • Lion King
  • 827643 View
  • 1074 Score
  • 3 Answer
  • Tags:   mysql sql join