Query String Empty why?

[timsharpe]

I am using the following form:

<? 

echo "<form method=\"post\"  action=\"hotsearch.php\">   

<input type=\"text\" name=\"make\" size=\"25\">   

<input type=\"submit\" value=\"Begin Searching!!\">   

</form> ";
?> 

The the database script is

<?php

$connection = mysql_connect ('localhost', 'user', 'pass');
if ($connection == false){
  echo mysql_errno().": ".mysql_error()."<BR>";
  exit;
}  

$query = mysql_query("SELECT * FROM autos where make like '$make'");
$result = mysql_db_query ("autos", $query);

if ($result){


  $numOfRows = mysql_num_rows ($result);
  for ($i = 0; $i < $numOfRows; $i++){
    $img_url = mysql_result ($result, $i, "img_url");
	$year = mysql_result ($result, $i, "year");
   	$make = mysql_result ($result, $i, "make");
	$comments = mysql_result ($result, $i, "comments");
	$price = mysql_result ($result, $i, "price");



echo "$year &nbsp; &nbsp;$make";

echo "$price";


  }



}
else{
  echo mysql_errno().": ".mysql_error()."<BR>";
}

mysql_close ();
?>

But it says that the query is empty why?

[drew010]

I would try changing
$query = mysql_query("SELECT FROM autos where make like '$make'");
to
$query = mysql_query("SELECT FROM autos where make like '%$make%'");

Add the % which is the wildcard character. I think the problem was in the like clause.
For example, if there is an entry [e-mail] and you run:
SELECT FROM table WHERE email LIKE 'johndoe';
It wont return that because its looking for the exact string johndoe. If you do:
SELECT FROM table WHERE email LIKE 'johndoe%';
it will return anything that has johndoe and any text after it.

Thats why i add the % before and after $make. Try that and see how it goes.

[xblue]

what's that supposed to be:

$query = mysql_query("SELECT * FROM autos where make like '$make'");
$result = mysql_db_query ("autos", $query);

mysql_query returns a resource identifier which you pass as argument to mysql_db_query (which shouldn't be used anyway) instead of a valid sql query.
😕

a better way:

// use % wildcards if your data needs it
$query = "SELECT * FROM autos where make like '$make'";
$result = mysql_query ($query) or die ("Error: ".mysql_error()." in query: ".$query);