I have a table with the following records:
+----+------------+--------------+
| id | title | url |
+----+------------+--------------+
| 1 | Olá Mundo! | ola-mundo-1 |
| 5 | Olá Mundo! | ola-mundo-3 |
| 6 | Olá Mundo! | ola-m...
I'm doing a very simple filtering system using PHP and mysql .
$stmt = $conexao->prepare("select * from filme where genero = '$genero'");
I'm wanting to put one in the genre list which, when selected, displays all the movies...
I always see tables as follows. Ex:
CREATE TABLE posts (
id int(11) NOT NULL,
titulo varchar(255) NOT NULL,
autor varchar(255) NOT NULL,
conteudo text NOT NULL,
data varchar(11) NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;...
How can I make more than one select in the same query? I tried the following (using UNION), but it did not work:
DATABASE
Table: lines_cameras
id_camera_linha | nome_linha_camera
Table: Manufacturers
id_fabricante | nome_fabri...
I have the following code in php:
$sql = "SELECT * FROM musicas_curtidas
GROUP BY musica
ORDER BY count(musica)
WHERE musica != 'Rádio Turn - Você em primeiro lugar!' AND
WHERE musica != 'Radio Turn - Não importa o seu estil...
I have a job to do where I enter name and two notes into a database using VoiceXML. I have two tables, one with nome , notaum , notadois and another with nome , media . How do I calculate the average of notaum...
I'm having trouble comparing strings.
One retreat from one EditText and the other from an SQL table.
The app consists of a game of the genre " Who wants to be a millionare? "
When it arrives at the if cycle of comparison between the two s...
I want to get the name of the columns of a table and their respective records .. Ex: I have the table registers and it has the columns name, login, password and there are 2 records recorded in this table, getting + - like this:
name = al...
I'm doing a select for a report of calls by carrier and each column of quantity, I have a select compound and that should return me the amount of calls from each carrier.
SELECT date(calldate) as 'Data',
(select count(*) FROM cdr where dstchan...
I need to make an appointment, to return the number of registrations registered in EVERY DAY, between two dates.
I'm using a MYSQL database, and I tried it here, but no form seemed to me correct.