CodeDump

SQL lower() on one side of WHERE statement works for part of result but not all?
MySQL
I will happily take an edit on the title - I have no clue what to call this. Basically, I'm looking for an explanation to something I just came across...
2 years ago

what is wrong with this query? I am trying to update a column value based on the value of a column in a second table
MySQL
So I am trying to update the value of column Proveedor_Logo in table Natan_Procesos with the value of column Proveedor_Logo in table Natan_Proveedor w...
2 years ago

Insert ArrayList into MySQL
MySQL
I trying to insert ArrayList into MySQL, but I only gets the last values in column selected_seats. The variable list holds value 2 and 3. When I check...
2 years ago

Fetch mysql data from PHP using radiobutton control
MySQL
I would like to manipulate PHP code to search for specfic data in the sql database that matched. For example, let's say I want to search for an IP ma...
2 years ago

MySQL Query 2 Tables Join Column beside
MySQL
I have 2 tables, called tb_compulsory_savings and tb_time_deposits for tb_compulsory_savings form_no | badge_id | compulsory_savings | transaction_d...
2 years ago

Insert data into Wordpress database yable from a custom form
MySQL
I am trying to insert data into Wordpress database by creating a table. I have created the table but when I try to insert the data from form, it does ...
2 years ago

Mysql : I need to search record where searched text is matched with third word
MySQL
I need to search record where searched text is matched with third word from database record. Example : Suppose i have three records in description fi...
2 years ago

Mysql Mathematics on the fly
MySQL
I am doing a migration from one database structure to another where there are rating values in a column. In database table A the rating is 0-10 in d...
2 years ago

MySQL COUNT values fo each column
MySQL
I’m trying to figure out how to count the values in more than one column. It seem the first COUNT I do gives me the correct results but everything I’v...
2 years ago

Best practices for efficiently storing md5 hashes in mysql
MySQL
Possible field types: BINARY(16) CHAR(32) BIGINT + BIGINT How do I decide which one to use? ...
2 years ago

Error SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=#
MySQL
I am facing a problem with my query ... SELECT keywords.keyword, keywords.keyid, sources.s_title, sources.s_disc, sources.s_link, sources.sourceid,...
2 years ago

Select unique values from Database
MySQL
Im having some troubles showing the unique values from my database. As an example, I have this very simple test table: Where you can see that ther...
2 years ago

Generate Visio ERD from existing MySQL Database
MySQL
Is there a simple way to generate an ERD in Visio from an existing MySQL Database? I'm aware that this is possible in MySQL Workbench, but I have a re...
2 years ago

Laravel (5.3) Eloquent - Relationship issue
MySQL
I have the following 3 tables which are normalised: `Table: TheMovies` id | MovieName --------------------- 1 | Zootopia 2 | Moana...
2 years ago

Does Laravel close automatically the DB connections?
MySQL
I'm working with Laravel and Databases (DB) using Eloquent and MySQL. I already found the code to close the DB connection, but I was searching on th...
2 years ago

Seperate MYSQL results into seperate HTML Tables
MySQL
I have the following in which I am trying to make seperate HTML tables after each group: $query = "SELECT * FROM NonBillableTime WHERE TimeIn LIKE '$...
2 years ago

MySql Query for one to many relationship
MySQL
Facing issue in mysql query, tried with mysql join but not getting expected output. I want all class, all student record with total ratingscore.Each ...
1 year ago

How fix error with PHP login that ask tow times for username and password
MySQL
when i want to login with this codes in first time i connect to internet, i enter the username and password and push submit and the page get refresh a...
1 year ago

mySQL Select from two tables and match result
MySQL
I'd like to SELECT DISTINCT column1, column2 as t1 And i'd like to SELECT column3 FROM table2 WHERE column4 = "1" AND column3 = (matches)t1.colu...
1 year ago

Don't add exact same 3 columns value in Mysql
MySQL
I need to add a CSV file in a database. But after I add one file, some weeks later I need to add a new update of the file. Problem is: Duplicate rows ...
1 year ago

Latest codedumps

treeview optimization
Dump SSH
DMAwithADC2
ADCwithDMA
Rendering
Receiving a message
Speak example
brenner
config.php
homecontroller.php
RGB_LED 2
RGB_LED
image crop resize rotate
Car.cs
Program.cs
Teams
Casts
get_array_nested_value
Simple + Multilang + Repeater
pbs report
vardump1
vardump
search.blade.php
SearchController.php
_create_products_table.php
emit_test.php
server.js
I am using the same thing. I am a beautiful person.
contact_mail.php
get_response.php