SQL Help

[Frostie]

This is probably a quickie, but having never needed it before, and plenty of searching I am still none the wiser.

I am showing data from a field in my database - say its called $field

This field contains something like the following;
abcdef=123&fghijk=234&WANTTHIS=123&thisthatandother=2345

Basically I just want to show the data in bold, that will always come after the WANTTHIS= piece of the field.

How do I say SELECT THIS, THAT AND RIGHT OF 'WANTTHIS=' BUT LEFT OF ']&thisthatandother'

Sometimes the 123 bit, may be 2345 or even 77777 (ie 3, 4 or 5 characters long).

Anyone?.... or Rich or 999gi ?

Thanks

[ianm]

You could Explode it using '&IWANTTHIS=' as the delimiter.

Then Explode the second element in the resulting array using '&thisthatandother=' as the delimiter.

The value you want would then be the first element of the resulting array

something like -

PHP Code:

  $array1 = explode ("&IWANTTHIS=", $field);
  $final_array = explode ("&thisthatandother=", $array1[1]);
  $myvalue = $final_array[0] 


[Frostie]

Thanks mate
EXPLODE = seperate
IMPLODE = glue

Works a treat now