[ theH @ 05.11.2007. 22:55 ] @
Imam zanimljiv problem. U MySql bazi imam tabelu u čijem polju imam zapise tipa
Code:
../../page.php?npr=One

Zanima me kako da pročitam samo ono One, bez ../../page.php?npr= ?
[ PHP @ 06.11.2007. 06:56 ] @
Code:

mysql> SELECT SUBSTRING('Quadratically',5);
        -> 'ratically'
mysql> SELECT SUBSTRING('foobarbar' FROM 4);
        -> 'barbar'
mysql> SELECT SUBSTRING('Quadratically',5,6);
        -> 'ratica'        
mysql> SELECT SUBSTRING('Sakila', -3);
        -> 'ila'        
mysql> SELECT SUBSTRING('Sakila', -5, 3);
        -> 'aki'
mysql> SELECT SUBSTRING('Sakila' FROM -4 FOR 2);
        -> 'ki'

[ theH @ 06.11.2007. 10:26 ] @
SELECT SUBSTRING!
Hvala!