From: | Sue Hanen <shanen(at)silverlink(dot)net> |
---|---|
To: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Trying to concatenate using a string variable and text |
Date: | 1999-02-27 03:02:44 |
Message-ID: | 01BE61BB.4892A020@silver170-44.silverlink.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
In the simplest form I need to built a query using a variable concatenated with some text. Something like this:
$query = "select * from table where fieldname $oper '$key[0]' "
And then I'd like to concatenate that $query with the following in a while loop:
$query = $query || " $logic fieldname $oper '$key[$i]' "
and when the while loop is done concatenate one last time with the following:
$query = $query || "order by fieldname"
$oper has been set to the regular expression characters ~ or ~* for case sensitivity
$logic has been set to OR
This code worked under PHP2 but I can't seem to get it to work under PHP3. I thought that all I would have to do is replace the plus sign (which was the concatenation character in PHP2 with the || which is the concatenation character in PHP3. I am new to PHP and any help I can get is greatly appreciated.
Sue
From | Date | Subject | |
---|---|---|---|
Next Message | Mauricio Carvalho de Oliveira | 1999-02-27 15:00:32 | Re: Trying to concatenate using a string variable and text |
Previous Message | Christophe Labouisse | 1999-02-26 22:45:00 | Re: [SQL] Unique Number KEY |