Questions tagged as 'mysql'

Tagged questions
1
answer

Update does not work in the database

I have the following code and when I submit it it does not update the NADA in the database. $query = "SELECT * FROM tests WHERE ID = :ID"; $result = $db->prepare($query); $result->execute(array(':ID' => $_REQUEST['ID']) ); if ($row =...
asked by 24.04.2015 / 21:18
1
answer

delete record from an sql table

Good people I want to erase a record from a table but for this I need to go get information from other tables and because of this I am not able to delete. I basically needed an SQL command that would receive the patient id from the patient t...
asked by 06.05.2015 / 20:39
2
answers

How to create a button if you are logged in to an account

Hello, I would like to know when someone is logged in to create a button of type FILE. This created the system of registration and login, but I do not know how to know when it is logged in or not. index.php <!DOCTYPE html PUBLIC "-...
asked by 01.05.2015 / 03:06
1
answer

Remove jQuery registry [closed]

I would like to click Delete, delete the record from the mySQL database .. Without giving reload to the page ... using jquery .. Does anyone know how to report? Thankful     
asked by 12.07.2015 / 04:51
1
answer

Union and order by together

Well I have in the MYSQL database the chatlogs table with: from, to, msg, datetime. Where are the messages exchanged and information ok, starting from this point I would like to know how to do a history of the messages, for example:    use...
asked by 11.03.2015 / 20:37
1
answer

Query MYSQL with predominance of WHERE clause

I have the following query (after all logic, ie the final query) SELECT * FROM cl_assistance AS CA LEFT JOIN cl_assistance_rel AS CREL ON CA.cod_assistance = CREL.rel_assistance WHERE latitude BETWEEN -24.22070591 AND -22.88033389 AND longitud...
asked by 10.03.2015 / 21:40
1
answer

create variable from the result of a query and use that variable in another query

is the following, so doing a query in the database with php! The code I use is the following: <?php $rs = $pdo->query(" SELECT * FROM licitacoes WHERE ID_USER = '$IDLOGADO' ")->fetchAll(); if(!$rs){ print_r($pdo->errorInfo()); }f...
asked by 12.02.2015 / 14:04
2
answers

Android connection with MySQL [duplicate]

Well, I got a free hosting from Hostinger I've set up MySQL right now, but would you like to know if it's possible for my android application to connect to that database? and if so how would I do it? would have to use webservice? would yo...
asked by 17.02.2015 / 14:14
5
answers

How to select a checkbox and retrieve data in the database?

I have 2 types of checkbox and I need to select one of the two to display a field of type input text with the information coming from the database. The input field will be disabled, that is, it will only be displayed. Doe...
asked by 15.02.2015 / 17:32
2
answers

While not stopping when you should

I have the following code: <div class="row"> <? $tag = mysqli_real_escape_string($connection,$_GET['categoria']); $result = $connection -> query("select * from produtos where tags like '%$tag%' and online='0' order by id limit 4...
asked by 19.01.2015 / 23:49