[RESOLVED] PHP MySQL SELECT problem?

NOJ75

Hi all,

Could someone please help me out with the following snippet of code:

  

  $bln = @$_REQUEST['mr_bln'];
  $gln = @$_REQUEST['mr_gln'];
  $dom = @$_REQUEST['mr_dom'];

  $query = "SELECT * FROM $table WHERE mr_bln =\"$bln\" OR mr_gln =\"$gln\" AND mr_dom = \"%$dom%\" ";

The problem I am having is that even though the query WILL display results found for the first $bln variable, it WILL NOT display any results for the $gln variable. Even though the database contains info for the $gln variable.

The same happens if I switch them round and put the $gln as the first part of the query, then nothing gets displayed for the $bln.

Does that make sence? Any help is much appreciated.

Kindest regards.

cgraz

Try adding in some parenthesis and printing the query string so you can see what is being passed to MySQL. I would pay attention to that as you may need to change your query depending on what variables are actually set.

  $query = "SELECT * FROM $table WHERE (mr_bln ='".$bln."' OR mr_gln ='".$gln."') 
     AND mr_dom = '%".$dom."%'"; 
  print $query;

Hopefully that doesn't give you any parse errors 😉

NOJ75

Unfortunately that did not do anything. It would not show any of the results using it. The query looked fine though.

cgraz

are you using mysql_error() after executing your query, to see if it returns anything?

After that, if mysql_error() doesn't return anything, manually take a look at your database to ensure that query would return results.

I also just realized you're using %, but there was no LIKE in your clause. Try this

 $query = "SELECT * FROM $table WHERE (mr_bln ='".$bln."' OR mr_gln ='".$gln."')
     AND mr_dom LIKE '%".$dom."%'";

NOJ75

That did the trick :rolleyes:

Thanks very much for your time. Much appreciated.

Kindest regards