SQL php prob coding

[nawal]

HOW TO COMBINE THEM IN IF ELSE CONDITION?I don’t knoe what to put in if( )

SQL Statement :

//Display All Data

$result = mysql_query("SELECT * FROM litrasInfo ORDER BY id ASC", $connect);

//Display Certain Data(Category, District, DUN, Parliament, Library Timetable)

$result = mysql_query("SELECT * FROM litrasInfo WHERE libCat = '$select'
OR district = '$select2'
OR dun = '$select3'
OR par = '$select4'
OR zone = '$select5'
ORDER BY id ASC",$connect);

//Display Certain Data2(Category / District / DUN / Parliament / Zone)

$result = mysql_query("SELECT * FROM litrasInfo WHERE libCat = '$select'
OR district = '$select2'
OR dun = '$select3'
OR par = '$select4'
OR zone = '$select5'
GROUP BY libCat = '$select'
OR district = '$select2'
OR dun = '$select3'
OR par = '$select4'
OR zone = '$select5'
ORDER BY id ASC",$connect);

//Display Certain Data3(Category / District / DUN / Parliament / Zone)

$result = mysql_query("SELECT * FROM litrasInfo WHERE libCat = '$select'
OR district = '$select2'
OR dun = '$select3'
OR par = '$select4'
OR zone = '$select5'
GROUP BY libCat = '$select'
OR district = '$select2'
OR dun = '$select3'
OR par = '$select4'
OR zone = '$select5'
HAVING libCat = '$select'
OR district = '$select2'
OR dun = '$select3'
OR par = '$select4'
OR zone = '$select5'
ORDER BY id ASC",$connect);

[bradgrafelman]

How do you know when to use the different SQL queries?

Are you going to code it in the link? i.e. "myscript.php?type=2" so it runs the 2nd query type?

We need to know more about how to decide which query to run depending on what circumstances.

A generic response would be use [man]switch/man like so:

switch($type) {

 case 1:

      $result = mysql_query("SELECT * FROM litrasInfo WHERE libCat = '$select' 
      OR district = '$select2' 
      OR dun = '$select3' 
      OR par = '$select4' 
      OR zone = '$select5' 
      ORDER BY id ASC",$connect); 
      break;

 case 2:

      $result = mysql_query("SELECT * FROM litrasInfo WHERE libCat = '$select' 
      OR district = '$select2' 
      OR dun = '$select3' 
      OR par = '$select4' 
      OR zone = '$select5' 
      GROUP BY libCat = '$select' 
      OR district = '$select2' 
      OR dun = '$select3' 
      OR par = '$select4' 
      OR zone = '$select5' 
      ORDER BY id ASC",$connect); 
      break;

 case 3:

      $result = mysql_query("SELECT * FROM litrasInfo WHERE libCat = '$select' 
      OR district = '$select2' 
      OR dun = '$select3' 
      OR par = '$select4' 
      OR zone = '$select5' 
      GROUP BY libCat = '$select' 
      OR district = '$select2' 
      OR dun = '$select3' 
      OR par = '$select4' 
      OR zone = '$select5' 
      HAVING libCat = '$select' 
      OR district = '$select2' 
      OR dun = '$select3' 
      OR par = '$select4' 
      OR zone = '$select5' 
      ORDER BY id ASC",$connect);
      break;

 case "all":

      $result = mysql_query("SELECT * FROM litrasInfo ORDER BY id ASC", $connect); 
      break;

 default:

      echo 'Invalid query type.';
      break;
}

[nawal]

this page is search from. For complete list, it will display all list and another is advance serach. I want 3 type of searchiing. I create :

(a) $result = mysql_query("SELECT * FROM litrasInfo ORDER BY id ASC", $connect); ->for display all

(b) $result = mysql_query("SELECT * FROM litrasInfo WHERE libCat = '$select'
OR district = '$select2'
OR dun = '$select3'
OR par = '$select4'
OR zone = '$select5'
ORDER BY id ASC",$connect); -> to display certain one category

but when i create this :

(c)$result = mysql_query("SELECT * FROM litrasInfo WHERE libCat = '$select'
OR district = '$select2'
OR dun = '$select3'
OR par = '$select4'
OR zone = '$select5'
GROUP BY libCat = '$select'
OR district = '$select2'
OR dun = '$select3'
OR par = '$select4'
OR zone = '$select5'
ORDER BY id ASC",$connect);

the result only display one result .why??