Posted by Geoff Berrow on 05/10/05 09:51

I noticed that Message-ID:
<1115594658.281075.129220@g14g2000cwa.googlegroups.com> from kiqyou_vf
contained the following:

>$query_search_results = sprintf("SELECT * FROM qcbd WHERE key_words
>LIKE '%%%s%%' ORDER BY client_id ASC", $colname_search_results);

The percentage char is a wild card. For instance %$myvar% would match
$myvar with anything in front and anything after.

If your $colname_search_results is empty you are saying where key words
= anything so you get all records.

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

• Next in forum: Re: Calculating week range from specific date - Any functions?
• Prev in forum: Re: Use of isset () in a string variabel
• Thread view: Re: Dreamweaver recordset will not give me null

[Reply to this message]