Welcome Guest, Not a member yet? Register   Sign In
Problem by select from db when there is a space followed by a comma in where clause
#3

[eluser]Libelle[/eluser]
Right, as I wrote it it is wrong. I don't use
Code:
$this->db->select('select val1..., but
$this->db->select('val1... - sorry, typo problem.

My statement is actually like

Code:
$this->db->select('col1, col2, count(*) from mytable1, mytable2 where col1 like ... and col3 like ... and col4 like ... and col5 in (select id from mytable3 where name like <here comes $where_clause>);

$where_clause is something like 'xxx xxx-xxx xxxx , xxxxx!' f.i.
It is processed like 'xxx xxx-xxx xxxx, xxxxx!' - xxxx, instead xxxx ,


Messages In This Thread
Problem by select from db when there is a space followed by a comma in where clause - by El Forum - 02-16-2012, 11:19 AM



Theme © iAndrew 2016 - Forum software by © MyBB