Questions tagged as 'mysql'

Tagged questions
1
answer

How do I not select records that are within a date?

I have a table in MySQL with apartment, like this: id | nome | data_ja_locado 1 | ap teste | 09/08/2015, 10/08/2015, 11/08/2015 Then when the user does a search he wants to find apartments that are available within a space of time. If...
asked by 21.07.2015 / 17:55
1
answer

Connection between 3 tables to retrieve information, sql

I have 3 tables with this structure Itriedbutcouldonlygetintotwotables,butIwouldneedtobeinthe3to"save / clean" code. It is necessary to enter in the table helpcenter_topics to get a 20 topics plus recentemente inseridos...
asked by 04.06.2015 / 01:46
1
answer

XAMPP - error with Apache

I installed XAMPP on my notebook, and it is with this error that I do not know what it is. 10:41:41 [mysql] Status change detected: stopped 10:41:41 [mysql] Error: MySQL shutdown unexpectedly. 10:41:41 [mysql] This may be due t...
asked by 07.06.2015 / 15:51
1
answer

Comment for each post id without multiplication of it

First look at my database image (the link arrows from one table to another are inner join 's): link Current Query: "SELECT question.*, questioncomments.*, login.* FROM questioncomments INNER JOIN question ON questioncomments.commen...
asked by 21.04.2015 / 21:31
1
answer

How to delete records from multiple tables at the same time?

I want to give delete in a student so I want to delete the records of that same student of all the tables where it is and its image of the folder where it is was guarded for this I use the following code: p> <?php /* * Verifica s...
asked by 21.04.2015 / 12:51
1
answer

Error saving field type null, not by field set to notnull

I'm trying to save a possible "client" but I'm not setting a date field for it, so when I do this the field is not set and it still gives error. Follow my PHP code, the bank all fields are null valid. <?php // incluindo o arquivo que fa...
asked by 31.07.2015 / 19:51
1
answer

Show DB information via combobox

I'm looking for a few days on the internet and I do not know if I'm looking for the wrong way, I just know that I can not find what I need. Next: I would like to click on one of the options that is in the ComboBox (or menu / list), which woul...
asked by 22.05.2015 / 03:26
1
answer

$ SESSIOn with durability

Hello, how can I complement the code below to work as I need the section to be destroyed once a day if the user creates SESSION on 08/18/2015 if he sees the same page with that SESSION on day 02/08/2015 forward it is destroyed only keeping the s...
asked by 30.07.2015 / 19:31
1
answer

Inserting data into SQL

Hello, I'd like to know how I can change area code 1 from insert using foreach ($ name as $ cod = > $ value) as the area code 2 I am not able to make an adaptation by changing the insert mode of code 2 so that foreach ($ name as $ cod...
asked by 09.04.2015 / 11:34
1
answer

How to select tables by prefix [MYSQL]?

I have 20 sets of different tables inside the same bank where each one corresponds to a virtual store. Since my tables are organized by prefix, how can I select all the tables in a given prefix to export? For example if I want to export the t...
asked by 03.06.2015 / 14:20