Questions tagged as 'mysql'

Tagged questions
0
answers

How to enter the local date in a mysql field

I have a table in mysql in which with a form I add the records and in them goes a field where the date in which the new entry was made is inserted. <input name="fechaingreso" type="hidden" value="<?= gmdate('d-m-Y H:i:s', time()) ?>"...
asked by 12.01.2018 / 17:50
2
answers

Modal of materialize does not open in hosting

I thank you for entering! It happens that everything inside the while disappears, if I have a button inside the while and another outside the while, only the one that is outside the while is shown, this is the code that I have: The HTML is t...
asked by 11.01.2018 / 23:16
0
answers

hello I want to join to one only 5 forms that every time I go filling up it is accumulating [closed]

I have a project with a table (data, documents, procedures, services, economy) and each one is in different forms I want to do one single and already saves edits it removes updates each one of the forms now I want to know as one everything that...
asked by 18.01.2018 / 17:07
2
answers

How to make an MYSQL query with WHERE conditional

Good morning everyone, I need help and I do not have an idea I'm putting together a query for a database, which gives me back a result (Table on the left) that contains a list of employees, and the amount that they charged per month. To this...
asked by 17.01.2018 / 21:41
0
answers

ASP and MySQL remote

For X reason I must make a connection from ASP (classic) hosted on server 1 (windows) to MySQL hosted on a server 2 (linux), I have installed the driver and makes the connection, but I get the following error:    [MySQL] [ODBC 5.3 (a) Driver]...
asked by 05.01.2018 / 15:58
0
answers

It does not show me correctly the error message in Mysql5.7 [closed]

in mysql5.1 if there is an error in the syntax it shows me the corresponding help with a clear description, but after installing the mysql5.7 I could not see that detail anymore. I would like to know if this behavior of 5.7 is normal or is a bug...
asked by 28.12.2017 / 16:00
2
answers

Concatenate two dates and format them in Mysql

I have the following problem, I need to concatenate two dates and format them, the two fields of dates that I want to concatenate, I just want to show a date, since the other one is regularly empty. Some products do not have a date, so it is pla...
asked by 04.01.2018 / 06:56
1
answer

Show all rooms, and know if it is free or occupied, according to a specific date

According to a specific date, show all the rooms, also show if it is free or not (that can be known with the reservation). So far I have managed to locate the reserved rooms: SELECT h.habitacion_numero as habitacion, r.inicio_fec...
asked by 15.12.2017 / 23:52
2
answers

How to apply a destroy () to a Top Level window?

I want to make my top level window close when I press the "Close" button that is located inside the top level itself. Could you tell me what's wrong? My code is as follows: def win2 (): t1 = Toplevel(bg="Brown") t1.title("Modificar Dat...
asked by 19.01.2018 / 23:09
0
answers

Unity with mysql

I have problems with Unity and mysql , trying to bring the only table I have in a database on the Square7 server, and what shows when calling what the table has is what they see in the image. : ( This is the php code <?php m_in...
asked by 20.01.2018 / 03:25