Lavarel 5.2 Conditional Update to Database

MySQL
How do I update a database column based on a value from a different column? I have a query like the following which pulls current usage (example: 200...
1 year ago

Table column name with regular expression using mysql

MySQL
Please let me know is that possible i am use regular expression or another idea to set query like, select name_en,name_ar,desc_en,desc_ar from table_...
1 year ago

Is it secure to Store value in var for PDO PHP?

MySQL
I wonder if it secure to store value for a prepared query like that : $notGood = 'yes'; $req = $pdo->prepare('SELECT id_user, name_user, tel_user,...
1 year ago

MySQL MATCH AGAINST not working

MySQL
I'm actually working on a website where there are two tables, almost identical, where MATCH AGAINST works on one but not on the other. To find out wh...
1 year ago

delete mysql using button and ajax

MySQL
I want to delete files in my database instantly when I put press button. Files were delete but I am obliged to refresh navigator. Ajax doesn't operate...
1 year ago

How to find time intersection between two times stored in mysql database

MySQL
The problem I'm facing is not very complicated and there are several answers to this here, but I didn't see any which is solving the problem as I need...
1 year ago

Mysql query with if exists check in where clause

MySQL
I have two tables (A and B) where my query compares a calculation from table A with a range in table B and then insert a corresponding value to the ra...
1 year ago

mysql query to count from related tables twice

MySQL
I'm having a problem getting my query the way I want it. I have 2 tables: Passages and Questions tables The questions table has a foreign key of a P...
1 year ago

Self-refering table. MySQL

MySQL
I have another question. I don't seem to fully grasp the concept. I have a table: EMPLOYEES | EMP_NO | APELLIDO | OFFICE | DIRECTOR | START_DATE | ...
1 year ago

How to format MySQL datetime to angular2 useable date format in Ionic 2?

MySQL
I am trying to format a mysql datetime that looks like this: 2016-05-27 20:17:45 to an useable date format for angular2. After reading some comments h...
1 year ago

Selecting minimum time for each unique column value where user is not banned

MySQL
I have a bunch of player records, a bunch of world records, and a bunch of banned players: describe records +--------+---------------+------+-----+-...
1 year ago

Query with subquery and having count(distinct) condition

MySQL
I'm attempting to create a query that lists the name and id of every horse which has finished in the top 3 in an event 2 or more times. These are th...
1 year ago

Filename stored on MYSQL is wrong for some reason

MySQL
I am getting a error in link genrated when fetched is beign fetched from database image of error here is code to fetching image echo "<img src='...
1 year ago

mysql. I want to get the max value of all rows with a specific date and use the corresponding fields

MySQL
My table 'players_online' id | count | date | time | day | max-players 0 | 55 | 26/05/16 | 13:00 | 5 | 300 1 | 33 | 26/05/16 | 13:...
1 year ago

Form field value not sent on update

MySQL
I have a form that allows a user to input scores for multiple students and specify which test (either test1, test2, or test3) the scores would be reco...
1 year ago

MySQL CROSS JOIN : Every Derived Table Must Have Its Own Alias

MySQL
I am trying to make a CROSS JOIN between "Selected" columns in two tables, For example : Table 1 (a, b, c) -- Table 2 (a, b, d) I want to select a an...
1 year ago

Unable to delete entry from table where value contains a space in the middle?

MySQL
I'm able to delete the entries which have a single word like 'Tomato' or 'Potato'. Unable to delete entries with multiple words like 'pumpkin soup'. ...
1 year ago

Mysql insert column and data from one table based on EXISTS

MySQL
Not sure why this won't work, trying to insert column(from table) and data(not from any table) from one table into another IF it isn't already there. ...
1 year ago

Your PHP installation appears to be missing the MySQL extension which is required by WordPress. On Ubuntu 14.04 LTS

MySQL
Your PHP installation appears to be missing the MySQL extension which is required by WordPress I tried to fix this problem by making sure MySQL serve...
1 year ago

Get datetime in a database and show it in 3 separate fields in dreamweaver [ year, month, day ]

MySQL
I am using xampp for my database and dreamweaver for my website. Fields in database : field 1 = id : int, primarykey and auto increment field...
1 year ago