On 2/15/2009 3:32 AM, "David Robley" <robl...@aapt.net.au> wrote:

> 
> LIKE '%c%' will match a field containing 'c' anywhere
> 
> If you are using that syntax, I'd suggest echoing your query to make sure
> that it is as it should be; I'm wondering if you are actually enclosing
> string values in single quotes in your query?

Thanks David for your help....

The input form is basic like:

<input name="Message" type="text" value="">

Then dreamweaver cs3 created this

$mess_list1 = "-1";
if (isset($_GET['Message'])) {
  $mess_list1 = $_GET['Message'];
}

... But it doesn't look like it does what you say : actually enclosing
string values in quotes....

Maybe ?: 


$mess_list1 = '$_GET['Message']';
Not 
$mess_list1 = $_GET['Message'];
???

> 
> As for multiple selection criteria, you need to test whether the passed in
> value is set or not, and only include set values in the query.

Not sure - but isn't that what this code is doing ...???


$mess_list1 = "-1";
if (isset($_GET['Message'])) {
  $mess_list1 = $_GET['Message'];
}

> 
> OT: sprintf syntax is so hard to read :-)

I agree - especially for this newbie...

--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists 09]




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to