esse e o erro
Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/setorcriat/public_html/test/buscar_db.php on line 43
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/setorcriat/public_html/test/buscar_db.php on line 43
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
esse e meu codigo
<table cellspacing="0" cellspacing="0" border="1" width="500">
<tr>
<td>ID</td>
<td>Nome</td>
<td>Dia</td>
<td>Mes</td>
<td>Ano</td>
<td>Email</td>
<td>Email ALternativo</td>
</tr>
<?php
session_start();
include "functions.php";
$sqlcon = "SELECT * FROM empresas";
if($_GET['buscar'] == 'buscar'){
//buscar todos
if($_GET['buscaNome'] == " " AND $_GET['buscaEmail'] == " " AND $_GET['buscames'] == " " AND $_GET['buscaano'] == " ") {
$sqlcon = "SELECT * FROM empresas";
}
//buscar nome
else if ($_GET['buscaNome'] != " " AND $_GET['buscaEsmail'] == " " AND $_GET['buscames'] == " " AND $_GET['buscaano'] == " ") {
$sqlcon = "SELECT * FROM empresas WHERE nome LINK '%".$_GET['buscaNome']."%' ";
}
//buscar email's
else if ($_GET['buscaNome'] == " " AND $_GET['buscaEsmail'] != " " AND $_GET['buscames'] == " " AND $_GET['buscaano'] == " ") {
$sqlcon = "SELECT * FROM empresas WHERE email LINK '%".$_GET['buscaEmail']."%' AND email2 LINK '%".$_GET['buscaEmail']."%' ";
}
//buscar todos por mes
else if ($_GET['buscaNome'] == " " AND $_GET['buscaEsmail'] == " " AND $_GET['buscames'] != " " AND $_GET['buscaano'] == " ") {
$sqlcon = "SELECT * FROM empresas WHERE mes LINK '%".$_GET['buscames']."%' ";
}
//buscar por ano
else if ($_GET['buscaNome'] == " " AND $_GET['buscaEsmail'] == " " AND $_GET['buscames'] == " " AND $_GET['buscaano'] != " ") {
$sqlcon = "SELECT * FROM empresas WHERE ano LINK '%".$_GET['buscaano']."%' ";
}
//buscar por mes e ano
else if ($_GET['buscaNome'] == " " AND $_GET['buscaEsmail'] == " " AND $_GET['buscames'] != " " AND $_GET['buscaano'] != " ") {
$sqlcon = "SELECT * FROM empresas WHERE mes LINK '%".$_GET['buscames']."%' AND ano LINK '%".$_GET['buscaano']."%'";
}
}
<font color=red>$resultado_001 = mysql_query($sqlcon) or die(mysql_error());</font> Linha 43
while ($rowcon = mysql_fetch_array($resultado_001)){
?>
<tr>
<td><? echo $rowcon['id'];?> </td>
<td><? echo $rowcon['nome'];?> </td>
<td><? echo $rowcon['dia'];?> </td>
<td><? echo $rowcon['mes'];?> </td>
<td><? echo $rowcon['ano'];?> </td>
<td><? echo $rowcon['email'];?> </td>
<td><? echo $rowcon['email2'];?> </td>
</tr>
<? } ?>
</table>
galera ajuda ae com dicas um outro modo falando oque fiz de errado
porque sinceramente nao estou vendo nda errado ae
Edição feita por: Henriquewow, 07/08/2012, 08:40.