Имам създадена база от данни с обяви и искам чрез търсачка да ги извлича по "град" и по "заглавие" (на обявата). Обаче скрипта дава грешка Error, query failed.
Ако имате идея къде греша - помагайте !
<?php
$tarsene = $_GET['search'];
$host = "localhost";
$db_username = "root";
$db_password = "parola";
$db_name = "test";
$con=mysql_connect("localhost", "root", "parola")or die("Can`t connect to DB");
mysql_select_db("test", $con) or die("cannot select DB");
$sql = mysql_query(" SELECT * FROM ads WHERE city LIKE '%$tarsene%' OR title LIKE '%$title%''") or die('Error, query failed');
$row = mysql_numrows($sql);
echo "Results for: <b><i>$tarsene</i></b>";
echo "<br />";
while($row = mysql_fetch_row($sql))
{
echo $row['city'].'<br>'.$row['title'].'<br>';
$city=$row['city'];
$title=$row['title'];
echo "$city<br />";
echo "$title<br />";
}
?>
Ако имате идея къде греша - помагайте !
<?php
$tarsene = $_GET['search'];
$host = "localhost";
$db_username = "root";
$db_password = "parola";
$db_name = "test";
$con=mysql_connect("localhost", "root", "parola")or die("Can`t connect to DB");
mysql_select_db("test", $con) or die("cannot select DB");
$sql = mysql_query(" SELECT * FROM ads WHERE city LIKE '%$tarsene%' OR title LIKE '%$title%''") or die('Error, query failed');
$row = mysql_numrows($sql);
echo "Results for: <b><i>$tarsene</i></b>";
echo "<br />";
while($row = mysql_fetch_row($sql))
{
echo $row['city'].'<br>'.$row['title'].'<br>';
$city=$row['city'];
$title=$row['title'];
echo "$city<br />";
echo "$title<br />";
}
?>