Questions tagged as 'mysql'

Tagged questions
1
answer

List / Static menu showing bank option

I wish I could understand a problem I have here. I created a static list / menu, but I need to leave marked option recorded in the database, when I have a table that allows me the relationship I make legal, as in this case: <?php mysq...
asked by 11.03.2014 / 17:56
2
answers

Search result in related tables

I have the following question, I have a ticket system to create calls and I need to do a search to bring the open calls sorted in order of priority, until now all right, I need now the field "$ row- > created_by "look for the name of the requ...
asked by 31.03.2015 / 16:17
1
answer

Execute a query when clicking the result of another query [closed]

I have the following column structure from my database: account_id, name and appearance. Image: link I had the following code before: <font size="3">Por favor digite o nome do personagem que deseja Resetar a Aparencia</font> &...
asked by 02.04.2015 / 13:01
3
answers

Why can not I connect to my MySQL server?

I'm trying to make a simple query using a PHP webservice. This is my current code: ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>(); nameValuePairs.add(new BasicNameValuePair("id", "1")); try {...
asked by 04.02.2014 / 21:15
1
answer

Define JRE construction project input path for 'JavaSE-1.7'

I'm trying to make a connection to MySQL database, but when I use PreparedStatement , eclipse returns: Definir projeto de construção JRE entrada caminho para 'JavaSE-1.7 Yes, I've changed the compiler version to 1.7, but only works...
asked by 04.02.2014 / 21:23
1
answer

Table already exists when creating a new mysql table, even if it does not exist

I have a database that accidentally deletes a table and when I try to recreate it, it says the table already exists, but it does not appear. When executing the command: SELECT * FROM INFORMATION_SCHEMA.TABLES She does not show up! How can I...
asked by 03.01.2019 / 10:07
1
answer

Rewrite the code to display expected result?

This code should return all records in the property table if the array is empty and return selected records if there are items in the array. I can get the array to be mounted and the database queried if I select at least one form item but I...
asked by 07.10.2014 / 04:28
1
answer

Storing a request in a variable resource server resource?

Using Wordpress I will need to use the article link more than once, I wanted to know if storing 'permalink' in a variable resource server resource, since I will only do one request to the database or there is an expense to process What does not...
asked by 08.10.2014 / 18:39
1
answer

InnerJoin no CodeIgniter

I'm working on a code and need to make an association, where I have to count the amount of voting in a video. The problem is that there are 2 tables of videos and votes . In videos is the videos, and there is the id of the video and...
asked by 16.09.2014 / 22:10
2
answers

How to get info from a database column through the GET method that I get from another page.

I'm new to php and database. I would like to know how to search the database for the "name", "password" "email" through the id I get via _GET from the previous page and display on the page that I am. To make it clearer. I have a page where th...
asked by 19.09.2014 / 02:10