Hello I hope you can help me
the truth is that I do not know how I can unite the results
SELECT
p.SKU,
p.pt_part,
p.pt_color,
p.pt_talla,
p.pt_draw,
p.pt_promo,
p.pt_desc1,
p.pt_rev,
o.pod_part,
o.po_n...
I am new with Ajax I try to upload files to my folder and store the path in my MySQL, these are my advances:
I have my modal window, with which you place the data of the file:
<form class="form-horizontal" action="../../phpcrud/create_do...
I am developing a fixed asset management system and I have a query that brings me information from different tables, one of the tables called kz_sgaf_distribdebajas (distribution of casualties) keeps records about asset losses that have b...
I have the following 3 tables:
CREATE TABLE tEstado
(idEstado INT NOT NULL AUTO_INCREMENT, Estado VARCHAR(100) NOT NULL,
PRIMARY KEY(idEstado), INDEX(idEstado))ENGINE=INNODB;
CREATE TABLE tMunicipio
(idMunicipio INT NOT NULL AUTO_IN...
I have a form with different inputs, of which the vast majority are not necessary to fill (and some of these are inputs that are related to other tables), my question is, when these inputs are empty, how do I do that are not added in the insert...
I have the following tables:
Tabla 1
----------
id
*fk_ciudades
datoX1
datoX2
Tabla 2
----------
idCiudades
nombreCiudades
And I want to make a query that selects one of the rows of Table 1 , when
a variable x that I pass, is equa...
I am trying to create an application of the type messenger. I connect to the database using node.js mysql. Each person who logs on the website is initially connected to a room for example: "room juan" (only John connects to this room) said room...
I have the database of DATA created in this format.
the code you use for the query is the following: only that the class table increases The column Bimester to demilitar the query.
<table class="table table-bordered table-striped t...
I have a problem in the trend of SQL in PHP
$where = '';
$sTable = "clientes";
$type = 'client(1);';
$usid = $_COOKIE['c_user'];
$where = "";;
if($_GET['q']!= "" ){
$where.= " WHERE fullname like '%$q%' AND user_id=1 ";
}
$whe...