Questions tagged as 'mysql'

Tagged questions
1
answer

How to use aliases in queries using Aliases along with MySQL?

I would like to be able to use the 'AS' alias along with mysql without having to do query alignment, ie I want secondary queries to be named so that I can use them in the main query, For example, in the case below the AS is used nested...
asked by 01.12.2017 / 17:04
1
answer

Querying cities without repetition and with "WHERE" different

When trying to resolve a platform bank issue hackerrank I could not understand the answer after having found it in the discussion wing. The question says:    Query a list of CITY names from STATION with even ID numbers only. You may prin...
asked by 01.12.2017 / 03:05
1
answer

Enter information in the bank with AJAX

I need to insert information into the database, but I need the page not to update. The problem is that I do not know anything about AJAX and even looking for the codes on the net, I could not solve How do I do: function setEpisodeComplet...
asked by 24.10.2017 / 22:24
1
answer

How to add columns from different tables?

I'm trying to set up an SQL command for my virtual store that returns the total value of the request, an item table (requestitemaux), and an additional table for the items (requestitemadaux). I mounted a command, but the error is occurring in My...
asked by 20.11.2017 / 23:52
1
answer

Error mysql_error ()="" and mysql_errno ()="0"

Sometimes in the system where work happens the following errors appear mysql_error() = "" and mysql_errno() = "0" , but this happens very rarely. My code: // Essa função está dentro de uma class do meu sistema // Exemplo : $sq...
asked by 21.11.2017 / 21:09
1
answer

How to update MySQL results automatically with JavaScript? [closed]

How do I automatically update MySQL queries with JavaScript? I was looking at the site and found something that helped me just put it on my site and when I went to see the server processes the second file query.php was opening more than 150 p...
asked by 21.11.2017 / 23:24
1
answer

I want to display data from a foreign key table in my main table, how do I do?

In PHP how do I instead of the foreign key id, the field that has the data appears? I have a room table that has column id , column nome and column tipo . And also I have the movie table, the movie rooms I've registered...
asked by 10.11.2017 / 20:54
1
answer

Difficulty in viewing and paging

I have a menu with the option to view the registered phones, only the numbers that were registered without showing the rest of the data, the intention and the user clicks on the option to view in the menu and opens a modal in this modal the numb...
asked by 30.11.2017 / 21:43
2
answers

How to insert value in mysql with PHP and Ajax

I have the following recipe page, which lists the ingredients: <?php $db->setQuery("Select * from #__ingredientes"); $tmpingredientes = $db->loadObjectList(); ?> And then I show you the list of ingredients. I wanted to put an...
asked by 23.10.2017 / 21:11
1
answer

psqlodbca.so: Unable to open file of shared objects: File or directory not found

I can not migrate the PostegreSql database to mysql because of this error:    psqlodbca.so: Unable to open shared object file:   File or directory not found I'm using ubuntu 64 Postgresql 9x and workbench 6.x, how should I proceed?...
asked by 23.10.2017 / 14:44