Skip site navigation (1) Skip section navigation (2)  Re:
display query results  Subject: Re: display query results Date:
2008-07-30 21:52:23 Message-ID: (view raw or whole thread)
Lists: pgsql-php Haha, no worries, I've had the same issue
before. It's almost certain that the text in your column does
not exactly match  "Alcohol" for one of a few reasons, e.g.
"Alcohol " (right-padding) " Alcohol" (left-padding) " Alcohol "
(padded both sides)  will not match = 'Alcohol' in the query.
Try trimming the data in that field - from PgAdmin or some other
query  tool, run something like:  |UPDATE glossary_item SET
"name" = |trim(both ' ' from "name")  WARNING: I've not tried
the above query so make sure you have a backup  of your data
before you run it ;-) Then try changing your PHP query back to =
again.   PJ wrote: > I want to thank everyone for their
contribution. As usual, the  > solution turns out to be simple.
Remeber the KISS principle. > see the note within the text: the
LIKE condition did it. But I will