Обсуждение: Help needed with regualr, or regexs expressions.

Hi,
I trying to return specific codes from the database, and the part of the
code that works when actually in the database is like this;

    => select code from catalog where code ~ '^1[a-zA-Z]';

This works, returning ONLY those codes from the table that contain the
number 1 in the first position, and non others.

However....  when placed in the php3 script, like this, it errors out?  What
am I doing wrong???/

(.... and code ~ '^$category[a-zA-Z]' order by code");


Thanks
Robert


---  http://4qir.quantum-radio.net.au - Where Only The Dedicated Survive!
4QIR Quantum Radio. Bringing you the original sounds of AFVN, with some of
the
original DJ's - back on air - and supporting not only the original Vets, in
comprehensive AFVN Archives, but putting together segments for the fighting
men and
women of todays services all around the world. World Music, for people of
the world.

Robert Chalmers wrote:
>
> Hi,
> I trying to return specific codes from the database, and the part of the
> code that works when actually in the database is like this;
>
>     => select code from catalog where code ~ '^1[a-zA-Z]';
>
> This works, returning ONLY those codes from the table that contain the
> number 1 in the first position, and non others.
>
> However....  when placed in the php3 script, like this, it errors out?  What
> am I doing wrong???/
>
> (.... and code ~ '^$category[a-zA-Z]' order by code");
>

try "'^".$category."[a-zA-Z]' ..."

--
CIMPOESU Teodor, Web Programmer

@ DIGICOM S.A. Bucharest, Romania
@ Internet, site development
@ teo@digiro.net,+(401)-330.47.28

official home page ~ http://www.digiro.net/
Internet  web page ~ http://internet.digiro.net/