To view the terms under which this email is distributed, please go to
http://disclaimer.leedsmet.ac.uk/email.htm
On 26 October 2004 12:01, John Holmes wrote:
> Sugimoto wrote:
> > Bad query: You have an error in your SQL syntax near 'and Tit like
> > and Aut like and Auty like ' at line 4
> [snip]
> > foreach ($_GET as $value) {
> > if (empty($value)) $value = "%";
>
> You have an issue here. You're looping through $_GET and attempting to
> set a default value (which is good), but you're not making
> any changes
> to $_GET at all, just resetting the same $value variable to '%'.
>
> foreach($_GET as $key=>$value)
> {
> if(empty($value))
> { $_GET[$key] = '%'; }
> }
Or, if I've been paying attention properly (which I might easily not have!
;), in PHP 5 you can do:
foreach ($_GET as &$value) {
if (empty($value)) $value = "%";
}
Cheers!
Mike
---------------------------------------------------------------------
Mike Ford, Electronic Information Services Adviser,
Learning Support Services, Learning & Information Services,
JG125, James Graham Building, Leeds Metropolitan University,
Headingley Campus, LEEDS, LS6 3QS, United Kingdom
Email: [EMAIL PROTECTED]
Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
