Personal beauty all? I've already gone through the entire forum and up to other forums and found no answers about it.
If anyone can take a look and point out my error thank you.
Follow the form below:
<form action="add.php" method="p...
If the title of my question was confused, I explain: I want to sort a result of a given query from MYSQL .
Example:
SELECT * FROM
usuarios
ORDER BY
cidade = 'BH' DESC,
cargo = 'Programador' DESC
But I would like tha...
How do I save data in the database in Brazilian format with accents, I used this in connection
mysqli_set_charset($conexão, 'utf8');
But now my code is all in PDO how do I save this data in utf8 in PHPMyadmin database?
<?php
/...
The select below returns something like
005-A Produto A 21/AGOSTO
005-A Produto A 20/AGOSTO
005-A Produto A 21/MAIO
005-B Produto B 21/AGOSTO
and I would like one record per product equal to the following
005-A Produto A 21/AGOSTO
005-B P...
I would like to know how I can fix the following problem I'm having with the alert response. I do INSERT of items to MySQL , so far so good. However, if some files fail and others can be sent in the loop warning, alert...
I'd like to know how to send a request to the database. in fact not a request but an insert for when I click on radio button it enter the value of radio button on the bank how do I do that?
I'm developing a software for a video store with MVC.
There are two problems: not changing people's attributes and displaying the following error:
java.sql.SQLException: Column 'code' not found '.
This error is saying that there i...
This is my code that makes a table listing
<?php
$consulta = mysql_query("SELECT * FROM mesas INNER JOIN pedidos WHERE pedidos.mesa = mesas.id and conta = 0");
if (mysql_num_rows($consulta)==true) {
while($lnmesas = mysql_...
I may be asking a silly question, but come on.
Does the order of columns in MYSQL interfere with performance in any way (either in writing or in research)?
Foreign keys are at the beginning or at the end, the fields type TEXT...