Questions tagged as 'mysql'

Tagged questions
2
answers

Inserting data in PHP

Good morning! I need a help Person I am facing the following problem I have two tables in the (clinics) and (users) I want to insert the data in the two tables in a way that is user- that the form is sent, the form data I've already m...
asked by 12.07.2016 / 15:11
1
answer

How to make an insert in mysql with data coming from a SimpleDataSet

I have a SimpleDataset with data from a Firebird location. I have to make a Insert in Mysql . How do I do this? Other SqlConnect and another SimpleDataSet ? How to do insert with data from this SimpleDataSet ( firebi...
asked by 14.07.2016 / 01:56
1
answer

You are not writing to the database, and the columns have numbers as names

This is a part of the code that is not writing to the database. Can you help me? case 'questao': include "conect.php"; $bd ="questoes"; $banco = mysqli_select_db($conexao,$bd) or (mysqli_error()); $categoria=$_POST[...
asked by 10.08.2016 / 01:11
1
answer

How to set% to integer in google charts

I have this chart:   Inthevisiblepartisthepercentage,howdoIchangethepercentagebythewholeamount: Example: Asshownintheattachedimageinsteadofshowing14.3%show1.Followmycode:<scripttype="text/javascript" src="https://www.gstatic.com/charts/loader...
asked by 08.08.2016 / 20:50
1
answer

Select with MYSQL when it exists in one table and in the other

I have two tables: QUIZ QUIZ_GERAL I would need to list data from both tables when: The logged in user ID is the same as the IDCONTA field OU When there is a line in the QUIZ table and there is no line in the QUIZ_GERAL...
asked by 10.08.2016 / 22:34
2
answers

Create more fields and avoid JOIN decreases load?

I have 3 tables that are linked: 1ª tabela: GRADE (grade de horários) Campos: ID - GRADE - ESTADO - VALIDADE 2ª tabela: BLOCOS (blocos de horários da grade) Campos: ID - ID_GRADE - BLOCO - DIA_SEMANA - DURACAO 3ª Tabela: COMERCIAIS resumi...
asked by 23.06.2016 / 21:09
1
answer

MySQL Query with RAND

Is there any way I can get MySQL records, where the is_new field is = 1, but when there are no records with the is_new = 1 field, I want the query to do an ORDER BY rand () is it possible? In practice, every time I make a select, I want to br...
asked by 22.06.2016 / 04:49
3
answers

Divide form with radii into 2 columns

I have the following form: <?php echo"<form class='form-horizontal' method='POST' action='reposicao.php'>"; echo"<fieldset>"; echo"<legend>OPÇÕES</legend>"; echo"<input type='hidden' name='loja' id...
asked by 23.06.2016 / 23:23
2
answers

Error 1093 in MySQL

Follow my code in MySQL: create schema if not exists Faculdade; use faculdade; create table if not exists Alunos ( RA integer UNSIGNED not null, senha varchar(15) not null, nome varchar(100) not null, faltas integer, PRIM...
asked by 29.08.2016 / 03:28
1
answer

Error trying to register data in the database (mysql) via PHP

I'm trying to insert some data into the database via php, but this is returning me error, apparently this is connecting, I can not find an error actually do not know much about php, I've been following tutorial on the internet, p> $(functio...
asked by 29.08.2016 / 16:05