error in mysqli query

Question

Person, how I fix this my code, it is giving error:

<?php
//IMPRIME TODOS OS VALORES DO BANCO CADASTRO

$servidor = "localhost";
$usuario  = "root";
$senha    = "admin";
$banco    = "cadastro";

//conecta-se ao banco de dados Mysql
$con = new mysqli($servidor, $usuario, $senha, $banco) or die("<script     language='javascript'>alert('Unable to connect to database')</script>"); 

// Verifica se ocorreu algum erro
if (mysqli_connect_errno()) {
die('Não foi possível conectar-se ao banco de dados: ' . mysqli_connect_error());
exit();
}
if(isset($_POST['buscar'])){
$q = mysql_real_escape_string($_POST['consulta']);
$query_Busca = "SELECT * FROM 'equipamento' WHERE 'tombamento' LIKE '%$q%'";
$Busca = $con->query($query_Busca);
$row_Busca = mysqli_fetch_array($Busca);
$totalRows_Busca = $Busca->num_rows;

} else {
$query_Busca = "SELECT * FROM 'equipamento'";
$Busca = $con->query($query_Busca);
$row_Busca = mysqli_fetch_array($Busca);
if (!$check1_res) {
printf("Error: %s\n", mysqli_error($con));
exit();
}
$totalRows_Busca = $Busca->num_rows;
}
?> 

The errors I get are: mysqli_fetch_array() expects Parameter 1 to be mysqli_result, Boolean Given AND THIS: Undefined variable: check1_res in C: wamp www register query.php on line 58

Answer 1

When making a query and table/field have special characters use:

`

Single quotes ' should only be used in text/Character values etc

change the occurrences:

$query_Busca = "SELECT * FROM 'equipamento'";

for:

$query_Busca = "SELECT * FROM `equipamento`";

or:

$query_Busca = "SELECT * FROM equipamento";

When executing a query remember to make it display database error like this:

$Busca = $con->query($query_Busca) or die($con->error);