2. PHPRunner General questions
  3. php eror
This topic is locked

php eror

 		10/17/2012 09:02:55
PHPRunner General questions
J
 jura author

Hello,
I have on my list page dropdown list - filtered results
After i select one of option in dropdown list i get this error:
[size="+2"]php greška[/size]

[size="+1"]Tehnička informacija[/size]Vrsta greÅ¡ke256Opis greÅ¡keIllegal mix of collations for operation 'like'URLwww.juraweb.hr/jurawebdizajn-faktura/Faktura_list.php?ctlSearchFor=Nepla%C4%8Deno&srchOptShowStatus=1&ctrlTypeComboStatus=0&srchWinShowStatus=0&a=integrated&id=1&criteria=and&type1=&value11=Nepla%C4%8Deno&field1=StatusRacuna&option1=Contains&not1=a=search&value=1GreÅ¡ka u podatku/home/uredws/public_html/jurawebdizajn-faktura/include/dbconnection.my.mysqli.phpGreÅ¡ka u redu42SQL upitselect count(*) FROM Faktura where (upper(tvr_GodRac) like upper('%Neplačeno%') or upper(StatusRacuna) like upper('%Neplačeno%') or DatumRacuna like '%Neplačeno%' or upper(kup_NazivKupca) like upper('%Neplačeno%') or upper(kup_PorBr) like upper('%Neplačeno%')) and ((1=1) and ((StatusRacuna = 'Neplačeno' or StatusRacuna like '%,Neplačeno,%' or StatusRacuna like '%,Neplačeno' or StatusRacuna like 'Neplačeno,%')))More info
I have one another similar dropdown list and work fine..
I dont understand why one work and another dont, principal is the same.
Help.
PHPRunner 6.1 latest build
C
 		cgphp 10/17/2012

Post the code of the dropdown list.
J
 		jura author 10/17/2012



Post the code of the dropdown list.


HERE IS CODE:
//create dropdown box

$str = "";

$str.= "<select onchange=\"window.location.href=this.options[this.".

"selectedIndex].value;\"><option value=\"\">Po statusu fakture</option>";

//select values from database

global $conn;

$strSQL = "select StatusRacuna from Faktura group by StatusRacuna";

$rs = db_query($strSQL,$conn);

while ($data = db_fetch_array($rs))

$str.="<option value=\"Faktura_list.php?ctlSearchFor=".$data["StatusRacuna"].

"&srchOptShowStatus=1&ctrlTypeComboStatus=0&srchWinShowStatus=0&a=".

"integrated&id=1&criteria=and&type1=&value11=".$data["StatusRacuna"].

"&field1=StatusRacuna&option1=Contains&not1=a=search&value=1\">".

$data["StatusRacuna"]."</option>";

$str.="</select>";

echo $str;
C
 		cgphp 10/17/2012

You have probably something wrong in the SQL where clause. Check the "Before SQL query" event.