filter

[girlzz]

hello sir.. can help me please..how to filter 2 data in one search??? i want to make searching according to s_code and group... the s_code work but the group not be filter... can anybody help me...??

[bluejay002]

please post your query so we can check it.

[girlzz]

$colname_mass = "-1";
if (isset($_GET['s_code'])) {
  $colname_mass = $_GET['s_code'];
}
mysql_select_db($database_mas, $mas);
$query_mass = sprintf("SELECT * FROM medic_registered_course WHERE s_code = %s", GetSQLValueString($colname_mass, "text"));
$mass = mysql_query($query_mass, $mas) or die(mysql_error());
$row_mass = mysql_fetch_assoc($mass);
$totalRows_mass = mysql_num_rows($mass);

[bluejay002]

mmm... can you post the actual query instead? am kinda lazy apprehending codes and all .

also, can you post the table structure and the filtering methods (the fields connected to)?

 

thanks,

 

jay

[girlzz]

sir, i just had this coding for filter... i'm want to filter s_code and group from medic_registered_course... can you give me more detail want you want to see?

[fenway]

I don't see two conditions...  and we want you to echo $query_mass.

[bluejay002]

yes, the actual query being submitted to mysql, not the php code. also, if you can post the structure of that table, please post it to, so we may know what to change in your query just in case.