url value not changing through loop

MySQL
I am trying to display the comments by the user from the database and +1 could be given to their comment. this is the view. <br>Comments:&l...
7 months ago

Wordpress error establishing a database connection - Memory Issue

MySQL
I have been running this wordpress site for a long time with no issues, however have recently been getting the error "Error establishing a database co...
7 months ago

Selecting MAX number from MySQL table not working - PHP

MySQL
I have a table like below (a piece); | Sl | NUMBER | Name | ---------------------- | 7 | 00007 | Name | ---------------------- | 8 | 00008 | Name...
7 months ago

Date Counting PHP

MySQL
I'm building a task list. I have two tables in my DB. Template and Tasks The templates are structured like so id, task_name, function, text, days_to_...
7 months ago

[My]SQL Query Syntax which requires foreach processing

MySQL
I have an SQL query task which I can do OK in C# or linqpad but would prefer it is in SQL so standard reporting tools can do it. End DB is a bugzill...
7 months ago

#1036 - Table is read only in phpMyAdmin

MySQL
i'm using a database host with phpMyAdmin. This host isn't mine. I execute this code in the phpMyAdmin of this host: INSERT INTO `fronton`(`id`, `Na...
7 months ago

Every derived table has its own alias

MySQL
i have the following query: select userid, name, checktime, campaign, CASE WHEN Hoursworked - 9 > 0 THEN Hoursworked - 9 ELSE 0 END Overtime from...
7 months ago

How to change MySQL column definition?

MySQL
I have a mySQL table called test: create table test( locationExpect varchar(120) NOT NULL; ); I want to change the locationExpect column to: c...
7 months ago

"day of month must be between 1 and last day of month" when looking for time in Oracle

MySQL
This may be rather simple, but i just don't get how to fix this. So this is rather a simple query i'm doing: SELECT TO_CHAR(DATE,'DD-MM-YYYY') AS DA...
7 months ago

Join query in MySQL

MySQL
I have two tables: members and renewals The two tables have a field called memberid which links the two data tables together. I am trying to constru...
7 months ago

Error: Can't connect to MySQL Server (110)

MySQL
I have a home-hosted MySQL Server which for some reason is giving me this: Connection failed: Can't connect to MySQL server on '9x.x.xxx.xx4' (111) ...
7 months ago

MySQL/MariaDB: Can't create a procedure using the case statement

MySQL
I am struggling with the case statement of MySQL. I want to use it in a procedure but I am getting an error (#1064 - You have an error in your SQL syn...
7 months ago

MySQL: get distinct, different, values between two queries

MySQL
I have a query with a sub-query. Both return a list of users IDs. in inner query gives me all customers who used cash in a particular location within ...
7 months ago

How can I UPDATE the result of a SELECT statement?

MySQL
I have a table like this: // notifications +----+--------------+------+---------+------------+ | id | event | seen | id_user | time_stamp | +-...
7 months ago

bind data on dropdownlist

MySQL
I'm trying run this code private void LoadProdName() { con.Open(); cmd = new SqlCommand(@"SELECT productName ...
7 months ago

Is there an SQLite equivalent to MySQL's DESCRIBE [table]?

MySQL
I'm just getting started learning SQLite. It would be nice to be able to see the details for a table, like MySQL's DESCRIBE [table]. PRAGMA table_info...
7 months ago

Select top rows from each group - MySql

MySQL
I have to retrieve the top rows from each group, based on the max values of two columns. This is the table: tag_series_id | tag_season_num | ...
7 months ago

Zeoslib in Delphi xe5 installation

MySQL
I am trying to install zeoslib in Delphi xe5 with no success. I keep getting a Ambiguous overloaded call to Char Inset error when I try to compile or...
7 months ago

Composite Primary Keys and auto increment? What is a good practices?

MySQL
I'm developing SaaS app with multi-tenancy, and i've decide to use single DB (MySQL Innodb for now) for client's data. I chose to use composite primar...
7 months ago

Information separating from mysql

MySQL
I'm making program for teachers with Java and mysql , so I've many tables in mysql such as students table which contains student name and number and I...
7 months ago