SELECT 'forma','id_produto','id_lanche','qtd_max',
if('id_lanche' in (select 'id_lanche' from 'produtos'
where 'id_lanche' = {$id_produto}),'checked','') as marca FROM 'formas'
Product DB = Products
db recipe = shapes...
I have an extensive form so I separated the HTML and several parts but I want to continue to save in the same table.
Example:
$sqlinsert = "INSERT INTO tb_detalhe_trabalhador (Nome1, Funcao1, MedicaValidade) VALUES ('".$Nome1."','".$Funcao1...
I have a script that calculates the total of values and then shows the total value in an echo. The problem is that the value is shown without any semicolons, eg: 82700 to: 827.00 I would like to convert it to decimal number but it still is not...
Hello, I'm developing a page in asp.net and I'm having difficulty passing values from a SELECT from Mysql to variables. I do not know where to start and would appreciate examples of how to do it.
I'm trying to get the id of a user that logged in and saved it in the session, but it's not working, I make a query in the database at the time of logging and I transform the result into an array to get the id and store it in the session , but t...
I have a form with a textarea and I'm not able to send the data typed in it to the MySQL database. How do I?
form.php
<form id="cadastro" name="cadastro" method="post" action = cadastro.php>
<textarea id="text_desc...
I have a java program that returns the list of users who have a query on that day, so I built a database that lists some important data of the users, the name of the doctor with whom they will have a query and some such as the living room and th...
Cite examples of applications, sites that would be best suited to use MySQL (or any other SGDB) or MongoDB. And the reason?
I still can not see scenarios that MongoDB is better.
Hello
I want to check the number of records in the database and display the number of records on the screen, but it is not working, what could be wrong?
<?php
include '../include/connection.php';
$query = "SELECT id FROM user...
I have a page with a form where it is inserted name, project, etc ... only when I click on submit form in Firefox or IE does not work, but Chrome works normally.
NOTE:
1- I had an old bank. When I change to this old address the Insert work...