Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

Will someone help with this MySQL Query?

I can't figure out why this query still shows results where PaidID=''.

The url calling this would be: ...?page=listing/results&State=FL

OR

$SEARCH="FL"; << Session

if (isset($_SESSION['search'])){
$SEARCH=$_SESSION['search'];
 
if (!ereg('[^0-9]', $SEARCH)){$searchResult = mysql_query("SELECT * FROM members WHERE ZipCodes LIKE '%$SEARCH%' AND PaidID!='' ");}
 
elseif (!ereg('[^A-Z]', $SEARCH) && (strlen($SEARCH) == 2)){
$searchResult = mysql_query("SELECT * FROM members WHERE PaidID!='' AND LicState LIKE '%$SEARCH%' OR LicState2 LIKE '%$SEARCH%' OR LicState3 LIKE '%$SEARCH%' OR LicState4 LIKE '%$SEARCH%' ");
}
 
elseif (isset($_GET['State'])){
 
$searchResult = mysql_query("SELECT * FROM members WHERE
 
(LicState='$State' AND Counties LIKE '%$SEARCH%') OR 
(LicState2='$State' AND Counties2 LIKE '%$SEARCH%') OR 
(LicState3='$State' AND Counties3 LIKE '%$SEARCH%') OR 
(LicState4='$State' AND Counties4 LIKE '%$SEARCH%')
 
AND PaidID!=''
 ");
 
}
 
elseif ($SEARCH=="EXAMPLE"){
$searchResult = mysql_query("SELECT * FROM members WHERE PaidID!='' ORDER BY RAND() LIMIT 5");
}
 
else{
$searchResult = mysql_query("SELECT * FROM members WHERE Counties LIKE '%$SEARCH%' OR Counties2 LIKE '%$SEARCH%' OR Counties3 LIKE '%$SEARCH%' OR Counties4 LIKE '%$SEARCH%'  PaidID!='' ");
}
 
if (!$searchResult){die(mysql_error());}
	
$num_rows= mysql_num_rows($searchResult);
 
}
 
if ($num_rows==0){include ("pages/listing/results_none.php");}
else{include ("pages/listing/results_found.php");}

Open in new window

0
phpretard
Asked:
phpretard
1 Solution
 
yeruhnCommented:
Use brackets in your query. Like:

SELECT * FROM members WHERE PaidID!='' AND (LicState LIKE '%$SEARCH%' OR LicState2 LIKE '%$SEARCH%' OR LicState3 LIKE '%$SEARCH%' OR LicState4 LIKE '%$SEARCH%' )

Dependent on what you want to select...
0
 
phpretardAuthor Commented:
Thank you!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now