I set two variables in MySQL to simplify another Query that I want to deploy to my system. Using this direct command in the DBMS, it works fine, however, when I want to use as a query string in my php script, it does not work. Gives an error in...
I have a question regarding accentuation, specifically the return of% with%. My bank has collation Ç , I'm using HTML tags:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html lang="pt-BR">
<head>...
I am making a code where the person adds records to the site that are shown to it in list in a table, in each row has a button to edit, when I edit some information all other records are changed, when I put a where at the end of the update code...
What is the best way to create the e-mail table, since the client can have multiple e-mail,
I created two situations one email_client and the other email?
What is the best way to handle query agility,
Could you help me?
Good Night,
I have a project where I need to compare which employee meets certain requirements, the bank structure looks like this:
I have a table with the punctuation required for each position and in each requirement, I wanted to k...
I have a page and need to display in the index a 4 thumbs with the latest products registered in my bank mysql, I want to do this using php. If anyone can help, I appreciate it. My index uses bootstrap 3.
Code used to get the result
<?php
$total = 0;
while($row = mysql_fetch_object($trabalho)) {
$total += $row->valor;
echo "<tr><td>$row->os</td><td>$row->d...
Save personal,
Here has an example that a guy from the community posted here
and I am trying to adapt my needs but an error arises:
#1248 - Every derived table must have its own alias
My query
SELECT
date_format(TABLE_2.data, '%d/%m/%Y...
Person, I have a problem. For example, I need to make a SELECT in a huge table, and I want it to return rows in the range of 10 by 10.
For example: 1,2,3,4,5,6,7,8,9,10 to 11,12,13,14,15,16,17,18,19,20 ,
and so on.
Cas...