Questions tagged as 'mysql'

Tagged questions
1
answer

Dropdown with JQuery / Ajax only sends data in first record

I'm dynamically dropping a dropdown for each item in a list returned in PHP. When selecting any of the dropdown items, this value is sent to an Update.php file, via JQuery and Ajax. The Dropdown: //Aqui tenho um while em PHP para criar um D...
asked by 19.07.2015 / 00:58
2
answers

mysql: unknown variable 'key_buffer = 16M'

On Linux, through the command line, when I try to login with: mysql -u root -p You should receive the prompt : Enter password: But instead I get the error: mysql: unknown variable 'key_buffer=16M' Where does this error originat...
asked by 13.01.2015 / 20:06
1
answer

How to join result of two tables 1 - n

I have the following problem. 1 client table that has relation to 1 table photos (respective client photos) relationship 1 client for "n" photos;    In short:       Client has id, name.       photo has client_id, content (bytes)....
asked by 12.01.2015 / 22:31
2
answers

Problem with UPDATE mysql

I have a problem executing an UPDATE command in my Database ... My table has 2 columns: -Column 1: link (PK) varchar -Column 2: statuz varchar I need to update only the "statuz" field in my table.    * change the value from "NEW" to "...
asked by 27.06.2015 / 09:00
1
answer

How to group DB values? [closed]

I am rephrasing this question more clearly. I have the following challenge; I have a BD that contains 16 fields of information, this BD keeps bets placed on a system, to later be able to process the result and payment of the customer's ticket. I...
asked by 29.06.2015 / 06:26
2
answers

Ensure that a set of functions work correctly

Hello everyone! I have a problem that is corroding and I think I will not be able to solve it alone ... It is the following: I have a form with a button; This button is responsible for selling a product. The sale is done in 3 steps: Discharge...
asked by 17.05.2015 / 20:51
3
answers

Can anyone cite examples for a user's status? (online & offline)

So I was thinking about getting the user table where status = online / strong>, but I know that when the user shuts down the computer without clicking Log out, the table will not be changed offline , so I want to know what is best: D...
asked by 13.05.2015 / 01:23
2
answers

I can not access my database

I have the following problem, I am trying to change the year of the dates I have in my database, and for this I am using: mysqli_fetch_row But I am not succeeding, returns always fails. I also made a connection to the database and apparentl...
asked by 11.05.2015 / 18:03
1
answer

Assign null value to a field

I was doing some testing on the local database, and for them I ended up modifying a field that was null , assigning a value to it. Now that I've done the tests, I want to re-assign the value null to that field. How can I do this?...
asked by 05.05.2015 / 20:08
2
answers

Could not resolve this reference. Could not locate the assembly "MySql.Data"

How do I add the reference "MySql.Data"? I'm using SharpDevelop and not Visual Studio !!     
asked by 01.05.2015 / 18:43