sql query problems

[franknu]

ok, i want that when the user select type and make and there is a Categories for  type and make to display what is on the database

the problem is that i am getting  No Results found any idea why

here is my code

[code=php:0]

$query =
  "SELECT * ".
  "FROM `business_info` ".
  "WHERE `make`=='make' ".
    "AND `type`=='type'".
    ((!empty($Categories)) ? " AND `Categories` LIKE '%".$Categories."%'":'');


$result = mysql_query($query) or die (mysql_error());
$num_result = mysql_num_rows($result);
  echo "<table>";
if($num_result <= 0){
    echo("No Results found.");
    exit;
[/code]

[Orio]

Dont use ==, you only need one =

[code]`make`=='make' //wrong
`make`='make'  //correct[/code]

Orio.

[franknu]

i did it with only one and i was still getting  No results found

i have a make, type and categories on the row

this one works
[code=php:0]

$query = "SELECT * FROM `business_info` WHERE  Categories LIKE '%".$Categories."%'";

[/code] but it only search for categories it doen't mind what is on type and make

please help

[franknu]

[code=php:0]

$query =
  "SELECT * ".
  "FROM `business_info` ".
  "WHERE `make`='make' ".
    "AND `type`='type'".
    ((!empty($Categories)) ? " AND `Categories` LIKE '%".$Categories."%'":'');
[/code]

[franknu]

thi is are new changes

[code=php:0]

$query =
  "SELECT *
  FROM `business_info`
  WHERE `make`='make'
    AND `type`='type'"
      AND Categories LIKE '%".$Categories."%'";
[/code]

but this is the error message that i got

Parse error: syntax error, unexpected T_STRING in /home/townsfin/public_html/business_display.php on line 45

[Round]

Try this

$query =
  "SELECT *
  FROM `business_info`
  WHERE `make`='make'
    AND `type`='type'"
      AND Categories LIKE \"%.$Categories.%\" ";

[franknu]

ok i made new changes and this is the new:

   code:

[code=php:0]

$query =
 "SELECT *
 FROM `business_info`
 WHERE `make`='make'
   AND `type`='type'
     AND Categories LIKE '%".$Categories."%'";
[/code]

message,  No Results  found

[franknu]

i tried the last code but no luck

No  Results found

[Round]

You will always have to use the backslashes when using wildcards and or variables


$query =
  "SELECT *
  FROM `business_info`
  WHERE `make`='make'
    AND `type`='type'"
      AND Categories LIKE \"%$Categories%\" ";

Try removing the fullstops

[franknu]

this is what i tried

[code=php:0]


$query =
  "SELECT *
  FROM `business_info`
  WHERE `make`='make'
    AND `type`='type'
      AND Categories LIKE \"%.$Categories.%\" ";
[/code]
displayed

No Results foun

[Round]

also shouldnt make and type be put into variables???

$query =
 "SELECT *
 FROM business_info
 WHERE make=\"$make\"
   AND type=\"$type\"
     AND Categories LIKE \"%$Categories%\" ";
cos otherwise you are searching for something that has make stored in the make field??

unless you want

$query =
  "SELECT make, type
  FROM business_info
  WHERE Categories LIKE \"%$Categories%\" ";

[Round]

take out the fullstops!!! [color=red].$Categories.[/color] becomes [color=red]$Categories[/color] no fullstops