help with string manipulation

[Gmunky]

If I have a string

 

$string = "SELECT * FROM TABLE WHERE AGE > 0 ORDER BY NAME";

 

how would I retrieve part of the string before 'ORDER';

 

i want this part 'SELECT * FROM TABLE WHERE AGE > 0'

 

if i use strstr($string,"ORDER"), this retrieves 'ORDER BY NAME'

 

is there an opposite function of strstr()?

[kenrbnsn]

You could use the explode() funciton:

<?php
$string = "SELECT * FROM TABLE WHERE AGE > 0 ORDER BY NAME";
list($part1,$part2) = explode(' ORDER',$string);
echo $part1;
?>

 

Ken

[Gmunky]

Thanks!