Questions tagged as 'mysql'

Tagged questions
1
answer

C # and mysql pagination

I have a form and a datagrid, in this form I am using a timer to do a search in mysql that fills the datasouce of the datagrid, so far everything is right. Now I need to limit the amount of search. For example: Select <campos> from tabel...
asked by 25.03.2015 / 13:22
2
answers

MySQL UPDATE multiple fields under the same condition (IF or CASE)

Friends, I need help. I have these 2 queries: UPDATE leilaov SET seconds = CASE WHEN (mesini = MONTH(NOW()) AND diaini = DAYOFMONTH(NOW()) AND horaini = HOUR(NOW()) AND minutoini <= MINUTE(NOW())) OR (mesini = MONTH(NOW())...
asked by 26.03.2015 / 19:57
1
answer

Double-reference the same table in another table

My question is this: I have to design a system for a health care institution that has internal physicians. There are users, and each user has an internal doctor. Each patient also has a family doctor of the SNS. A doctor can be an internal do...
asked by 25.03.2015 / 20:52
1
answer

Function to replace character does not work when data comes from mysql

I use a function to replace characters with accents or special characters, but when I used the same function with data coming from MySQL the function is not replacing characters. Assuming the city is Foz do Iguaçu , the function...
asked by 06.06.2015 / 03:20
1
answer

Database backup when clicking on a link

I need a superuser on my system to export the database by clicking "backup", and force the download of the script from PHP as phpMyAdmin does. It is possible? If yes, how? If not, is there any way I can do something similar?     
asked by 24.03.2015 / 03:19
1
answer

Change table in mysql

I have the following situation. A table that displays the search results in mysql, and inside that table I have a column where the edit button is. How do I make this button edit content displayed on that line? I'm using the while lo...
asked by 14.03.2015 / 02:42
1
answer

Relationship between tables in MySQL

I am creating a website and I have a problem with it, in this site I will show some characters in the game League of Legends and show which character is strong or weak in relation to others, 1 is strong against character 2 but is weak against...
asked by 10.03.2015 / 21:12
1
answer

Previous record Mysql

Hello, I'm trying to see the previous record in relation to the current record. I am using the following code SELECT * FROM Tabela WHERE compoid <"Contraband" ORDER BY compoid DESC LIMIT 1; But it is returning the blank table What's wron...
asked by 27.03.2015 / 22:38
1
answer

PHP return data from the database

I am trying to make a select in the database for testing, this select displays the user data after entering username and password. The error happens after select :    Warning: mysql_fetch_array () expects parameter 1 to be...
asked by 27.03.2015 / 12:11
1
answer

key of the same table

Do you talk beauty? I'm doing an infinite category system, so in the table has the code and code of the parent category. I would like to relate these two fields to when I delete a category the child is deleted too, so I do not need to treat v...
asked by 27.03.2015 / 20:14