Posts by Rafael Silva • 141 points
7 posts
-
2
votes2
answers261
viewsQ: Update with character in the middle of the string
I have thousands of records with a code in a very peculiar format that identifies boxes on streetlights. Ex.: 21.305-005/100a However, this code is currently in 21305005100-A format. As the position…
mysqlasked Rafael Silva 141 -
2
votes1
answer26
viewsQ: Record values of a related table concatenated in the main entity query
I have two tables: ordem_servico and ordem_servico_tecnicos. If more than one technician is required for an O.S., records of each technician are created in the second related table by the order…
mysqlasked Rafael Silva 141 -
1
votes1
answer91
viewsQ: List records without reference in another table
I have three tables: -customers -plans -services On the table services have servico_A, servico_B and servico_C that are related in the table plans. I need to list all customers who do not have a…
-
3
votes1
answer123
viewsQ: Locate specific day of the week between dates
I have the following code to release on an agenda days and times available and for that I use the following routine: //recebo dados do formulario //inclusive o dia da semana ex.: Friday $dia_semana…
-
0
votes0
answers47
viewsQ: Logic. Company with 2 stocks
I have the following Mysql table: `estoque_itensconsumo` ( `cod_itensconsumo` INT NOT NULL AUTO_INCREMENT, `unidade_mendida` VARCHAR(45) NULL, `estoque_atual` INT NULL, `quant_minima` INT NULL,…
mysqlasked Rafael Silva 141 -
3
votes1
answer536
viewsQ: Pass a query array to all Codeigniter pages
Has a view that repeats itself in all others through a $this->load->view('menu'); would have a way to load the dynamic menu query in all other views with the line above? If I do this on all…
-
2
votes2
answers644
viewsA: Error in select with PHP + Mysqli
<?php $mysqli = new mysqli('localhost', 'root', '', 'dog_house'); if(!$mysqli) die(mysql_error()); $codigo = $_GET['cod']; echo $codigo;//Ver a PK //aqui vc deve colocar o nome do campo com PK…