can i Double query in the sale loop

[franknu]

Can i do double query

 

for example i want this code to search

if(!$Categories ||!$make){

  echo "You have not enter all fields";
  exit;
  }
$db = mysql_connect($host, $username, $password) or die(mysql_error()); 
mysql_select_db($database) or die(mysql_error()); 


$bizwebpage2 = (isset($_FILES['bizwebpage2']) ? $_FILES['bizwebpage2']:'');
$Picture1 =  (isset($_FILES['Picture1']) ? $_FILES['Picture1']:'');


if(isset($_GET['Categories'])){
    $Categories = addslashes($_GET['Categories']);
    }
    else
{
    echo(""); 
}

$query = 
  "SELECT * 
  FROM business_info 
  WHERE make=\"$make\" 
    AND type=\"$type\"
      AND Categories LIKE \"%$Categories%\" ";
  OR
here is the line what i want to add 
$query = "SELECT * FROM business info WHERE make =\"$make\"
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 With this word.  Please try similars words or<br>
    Look for surrounding <b>Towns </b>or  just <b> State.</b> <br>
<a href="index.php"> GO BACK </a>
.");
    exit;
}

This is the error that i get

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

 

[taith]

somin like this...

 

$query="SELECT * FROM business_info WHERE ((make=\"$make\" AND type=\"$type\") ||(make =\"$make\"
AND Categories like \"%$Categories%\"))AND Categories LIKE \"%$Categories%\" ";

[franknu]

ok that works my problem now is this some of the this are repeating how can i tell that if they are already there show only once. any peace of advise

 

[franknu]

i made some changes to make work more efficience here is the eror

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') || (make ="Massachusetts" AND Categories like "%nightclub%") "' at line 1

 

 

here is my code

$query="SELECT * FROM business_info WHERE ((make=\"$make\" AND type=\"$type\")AND Categories like \"%$Categories%\"))
|| (make =\"$make\"
AND Categories like \"%$Categories%\") \" ";

[per1os]

In MySQL you use single quotes to enclose variables. IE:

 

<?php
$query="SELECT * FROM business_info WHERE ((make='$make' AND type='$type')AND Categories like '%$Categories%'))
|| (make ='$make'
AND Categories like '%$Categories%')";

 

Proper syntax helps sometimes.

[franknu]

ok I keep gettin the same error

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') || (make ='Massachusetts' AND Categories like '%nightclub%')' at line 1

[per1os]

<?php
$query="SELECT * FROM business_info WHERE ((make='$make' AND type='$type') AND Categories like '%$Categories%'))
|| (make ='$make'
AND Categories like '%$Categories%')";

 

Probably should have a space between the ) and the AND. See if that works.

[taith]

<?php

$query="SELECT * FROM business_info WHERE ((make='$make' AND type='$type') AND Categories like '%$Categories%') || (make ='$make' AND Categories like '%$Categories%'))";

 

nope... the first categories had 2 )'s... where it only shoulda had one, and should be at the end

[franknu]

ok, This is my new code:

$query="SELECT * FROM business_info WHERE ((make='$make' AND type='$type') AND Categories like '%$Categories%') || (make ='$make' AND Categories like '%$Categories%'))";

 

and here is my display

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

[franknu]

ok this one is working

 

$query="SELECT * FROM business_info WHERE ((make='$make' AND type='$type' AND Categories like '%$Categories%') || (make ='$make' AND Categories like '%$Categories%'))";

 

the only problem is that is selecting the whole database basicly is doing the last statement

 

(make ='$make' AND Categories like '%$Categories%'))";

 

 

[taith]

which would just be a logic issue... first one grabs limits by type... second one doesnt...

[sasa]

if you try to use typo criteria only if $typo !=''

$query="SELECT * FROM business_info WHERE make='$make' AND (type='$type' OR ''='$type') AND Categories like '%$Categories%'"

[franknu]

it is not giving me any results for make so if i only select make it doest get me any results

[franknu]

works great now

 

so my only problem is that it is repeating certain things because it is finding an in diffrent type so how can i tell it so if  something show us up only repeat once

[taith]

you'd need to use group by and distinct()... i'd explain it... but i'm a bit rushed at the moment :-)