Stupid Question?! ltrim hates the letter N ??

[scotchegg78]

what the devil is going on here...

 

echo $oldqry;
$newsql = ltrim($oldqry," AND");
echo $newsql;

 

give this!

before trim .. AND NetworkID LIKE

after trim...etworkID LIKE '3

 

wheres my N gone!

[Hypnos]

Because you set the second parameter on ltrim. The second parameter is what characters you want to strip.

 

Looks like you're trying to strip away that "AND". This is a slightly better way:

 

$newsql = str_replace(" AND", $oldqry);

[scotchegg78]

hi thanks for the reply, but will this not replace all " AND" s in the string? there may be many of these.

And i know i want it to strip the word AND from the start, but not the N from NetworksID ?!

[MadTechie]

try this

$newsql = preg_replace('/^AND|AND$/si', '', $oldqry);

 

EDIT: Opps

Ltrim version

$newsql = preg_replace('/^AND/si', '', $oldqry);

 

Rtrim version

$newsql = preg_replace('/AND$/si', '', $oldqry);